
Component family |
Databases/DB Generic |
|
Function |
tDBSQLRow is the generic NoteFor performance reasons, specific DB component should always |
|
Purpose |
Depending on the nature of the query and the database, tDBSQLRow acts on the actual DB structure NoteTo use this component, relevant DBMSs’ ODBC drivers should be |
|
Basic settings |
Property type |
Either Built-in or Since version 5.6, both the Built-In mode and the Repository mode are |
|
|
Built-in: No property data stored |
|
|
Repository: Select the repository |
|
Datasource |
Name of the data source defined via the database connection |
|
Username and |
DB user authentication data. To enter the password, click the […] button next to the |
|
Schema and Edit |
A schema is a row description. It defines the number of fields to be processed and passed on Since version 5.6, both the Built-In mode and the Repository mode are |
|
|
Built-In: You create and store the schema locally for this |
|
|
Repository: You have already created the schema and |
Click Edit schema to make changes to the schema. If the
|
||
|
Table Name |
Name of the source table where changes made to data should be |
|
Query type |
Either Built-in or Since version 5.6, both the Built-In mode and the Repository mode are |
|
|
Built-in: Fill in manually the |
|
|
Repository: Select the relevant |
|
Query |
Enter your DB query paying particularly attention to properly |
Die on error |
This check box is cleared by default, meaning to skip the row on |
|
Advanced settings |
Additional JDBC parameters |
Specify additional connection properties for the database NoteYou can set the encoding parameters through this field. |
Propagate QUERY’s recordset |
Select this check box to insert the result of the query into a |
|
|
Use PreparedStatement |
Select this check box if you want to query the database using a
Parameter Index: Enter the
Parameter Type: Enter the parameter
Parameter Value: Enter the NoteThis option is very useful if you need to execute the same |
|
Commit every |
Number of rows to be completed before committing batches of rows |
|
tStatCatcher Statistics |
Select this check box to collect log data at the component |
Global Variables |
QUERY: the SQL query statement being processed. This is a ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see Talend Studio |
|
Usage |
This component offers the flexibility of the DB query and covers Note that the relevant DBRow component should be preferred |
|
Log4j |
The activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User For more information on the log4j logging levels, see the Apache documentation at http://logging.apache.org/log4j/1.2/apidocs/org/apache/log4j/Level.html. |
This scenario describes a single component Job which aims at re-initializing the DB
auto-increment to 1. This job has no output and is generally to be used before running a
script.
Warning
As a prerequisite of this Job, the relevant DBMS’s ODBC
driver must have been installed and the corresponding ODBC connection must have
been configured.
-
Drag and drop a tDBSQLRow component from the
Palette to the design workspace. -
Double-click tDBSQLRow to open its Basic settings view.
-
Select Repository in the Property Type list as the ODBC connection has been
configured and saved in the Repository. The follow-up fields gets filled in
automatically.For more information on storing DB connections in the Repository, see
Talend Studio User Guide. -
The Schema is built-in for this Job and it
does not really matter in this example as the action is made on the table
auto-increment and not on data. -
The Query type is also built-in. Click on the
[…] button next to the Query statement box to launch the SQLbuilder editor,
or else type in directly in the statement box:Alter table <TableName> auto_increment = 1
-
Press Ctrl+S to save the Job and F6 to run.
The database autoincrement is reset to 1.