How can I use tSQLTemplate component?

[gko1610709171]

Hi. I`m a new in Talend.

Making a new development format with Talend, I have a trouble with common SQL.

I`d like to make common SQL to get common value each job and tried below.

1. made UserDefined SQL in SQL Template.
2. set SQL from 1 using tSQLTemplate component.
3. to set result of tSQLTemplate, connect to tSetGlobalVar component.

I chose tSQLTemplate to set SELECT SQL

but tSQLTemplateAggregate.

but I don`t know how I can use tSQLTemplate properly. Talend manual said just detail of component but usage.

Is there somebody who help me plaese?

like connection usage,

tDBConnection - tSQLTemplate - nextComponent(?)

[Anonymous]

Hello,

As a start component, tSQLTemplate component is used with other database components, especially the database connection and commit components.

Such as, tDBConnection -->OnSubjobOK--> tSQLTemplate_1 --> tDBClose

Best regards

Sabrina