Reference

The following sections cover in more detail specific functional features and usage scenarios of the JDBC connector.

Properties reference: JDBC connector
This topic lists all properties that you can set to configure the stage.
Runtime column propagation
You can configure a JDBC Connector stage to automatically add columns to its output link at run time.
Column derivations
When the connector uses a SELECT statement to read rows from the data source, the connector must map the column names that are returned by the SELECT statement to the columns that are defined on the output link.
Reject conditions
When you use the JDBC connector to write data to a JDBC data source, you can add a reject link to the JDBC Connector stage and send rejected records to the stage attached to the other end of the link. Reject conditions determine when a record is rejected.
Partitioned reads
The JDBC Connector stage can be configured to run on multiple processing nodes and read data from the data source. In this scenario each of the processing nodes for the stage retrieves a set (partition) of records from the data source. The partitions are then combined to produce the entire result set for the output link of the stage.
Supported write modes
When you configure the JDBC connector as a target, you can use the Write mode property to specify the mode to use to write rows to the JDBC data source.
Data type mappings
InfoSphere® DataStage® supports data types that are different from Java™ and JDBC data types. To complete its operations, the connector must map the data types depending on the scenario in which the connector is used.
Performance optimization
You can configure various settings in the JDBC Connector stage that might optimize its performance.

Parent topic: JDBC data sources