To access a system SQL template, expand the SQL Templates node in the Repository tree view.
Each folder contains a system sub-folder containing pre-defined SQL statements, as well as a UserDefined folder in which you can store SQL statements that you have created or customized.
Each system folder contains several types of SQL templates, each designed to accomplish a dedicated task.
Apart from the Generic folder, the SQL templates are grouped into different folders according to the type of database for which they are to be used. The templates in the Generic folder are standard, for use in any database. You can use these as a basis from which you can develop more specific SQL templates than those defined in Talend Studio.
The system folders and their content are read only.
From the Repository tree view, proceed as follows to open an SQL template:
In the Repository tree view, expand SQL Templates and browse to the template you want to open.
Double-click the class that you want to open, for example, Aggregate in the Generic folder.
The Aggregate template view displays in the workspace.
You can read the predefined Aggregate statements in the template view.
The parameters, such as
operation, are to
be defined when you design related Jobs. Then the parameters can be easily set in the
associated components, as mentioned in the previous section.
Everytime you click or open an SQL template, its corresponding property view displays at the bottom of the studio. Click the Aggregate template, for example, to view its properties as presented below:
For further information regarding the different types of SQL templates, see Types of system SQL templates
For further information about how to use the SQL templates with the associated components, see in Talend Open Studio for Big Data Components Reference Guide.