tELTSybaseOutput
Performs the action (insert, update or delete) on data in the specified Sybase
table through the SQL statement generated by the tELTSybaseMap
component.
The three ELT Sybase components are closely related, in
terms of their operating conditions. These components should be used to handle Sybase
database table schemas to generate SQL statements, including clauses, which are to be
executed in the database output table defined.
tELTSybaseOutput Standard properties
These properties are used to configure tELTSybaseOutput running in the Standard Job framework.
The Standard
tELTSybaseOutput component belongs to the
ELT family.
The component in this framework is available in all Talend
products.
Basic settings
Action on data |
On the data of the table defined, you can perform the following
Insert: Add new entries to the table. If duplicates are Update: Updates entries in the table.
Delete: Deletes the entries which |
Schema and Edit |
A schema is a row description, that is to say, it defines the Click Edit
|
 |
Built-in: The schema is created and |
 |
Repository: The schema already exists |
Where clauses for (for UPDATE and DELETE |
Enter a clause to filter the data to be updated or deleted |
Default Table Name |
Enter a default name for the table, between double quotation Note that the table must exist already. If it |
Default Schema Name |
Enter a default name for the Sybase schema, between double |
Table name from connection name is |
Select this check box when the name of the connection to this |
Use different table name |
Select this check box to enter a different output table name, |
Mapping |
Specify the metadata mapping file |
Advanced settings
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at a Job |
Global Variables
Global Variables |
NB_LINE: the number of rows read by an input component or
NB_LINE_INSERTED: the number of rows inserted. This is an
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 |
tELTSybaseOutput is intended for Note:
ELT components only handle schema information. They |
Limitation |
This component requires installation of its related jar files. |