tSybaseRow
Acts on the actual DB structure or on the data (although without handling data).
tSybaseRow is the specific component
for this database query. It executes the SQL query stated onto the specified database.
The row suffix means the component implements a flow in the job design although it
doesn’t provide output.
The SQLBuilder tool helps you write easily your SQL statements.
tSybaseRow Standard properties
These properties are used to configure tSybaseRow running in the Standard Job framework.
The Standard
tSybaseRow component belongs to the Databases family.
The component in this framework is available in all Talend
products.
connector. The properties related to database settings vary depending on your database
type selection. For more information about dynamic database connectors, see Dynamic database components.
Basic settings
Database |
Select a type of database from the list and click |
Property type |
Either Built-in |
 |
Built-in: No property data stored |
 |
Repository: Select the repository |
Use an existing connection |
Select this check box and in the Component List click the relevant connection component to Note: When a Job contains the parent Job and the child Job, if you
need to share an existing connection between the two levels, for example, to share the connection created by the parent Job with the child Job, you have to:
For an example about how to share a database connection |
DB Version |
Select the version of the Sybase database to be used from the |
Server |
Database server IP address |
Port |
Listening port number of DB server. |
Database |
Name of the database |
Sybase Schema |
Exact name of the sybase schema. |
Username and Password |
DB user authentication data. To enter the password, click the […] button next to the |
Table Name |
Name of the table to be processed. |
Turn on identity insert |
Select this check box to use your own sequence for the |
Schema and Edit Schema |
A schema is a row description. It defines the number of fields |
 |
Built-In: You create and store the schema locally for this component |
 |
Repository: You have already created the schema and stored it in the |
 |
Click Edit
|
Query type |
Either Built-in or Repository |
 |
Built-in: Fill in manually the |
 |
Repository: Select the relevant |
Query |
Enter your DB query paying particularly attention to |
Die on error |
This check box is selected by default. Clear the check |
Advanced settings
Propagate QUERY’s recordset |
Select this check box to insert the result of the query into a Note:
This option allows the component to have a different schema |
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 Note:
This option is very useful if you need to execute the same |
Commit every |
Number of rows to be completed before committing batches of rows |
tStat |
Select this check box to collect log data at the component |
Global Variables
Global Variables |
QUERY: the query statement being processed. This is a Flow
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 |
Usage
Usage rule |
This component offers the flexibility of the DB query and covers |
Dynamic settings |
Click the [+] button to add a row in the table The Dynamic settings table is For examples on using dynamic parameters, see Reading data from databases through context-based dynamic connections and Reading data from different MySQL databases using dynamically loaded connection parameters. For more information on Dynamic |
Limitation |
This component requires installation of its related jar files. |
Related scenarios
For tSybaseRow related topics, see: