Search

PowerExchange for JDBC V2 User Guide

PowerExchange for JDBC V2 User Guide

10.5.6
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5.2
- 10.5
- 10.4.0

Back Next

Advanced Properties

Advanced Properties

You can use the advanced properties to specify data object write operation properties to write data to a JDBC V2 server.

The following table describes the advanced properties that you configure for a JDBC V2 write operation:

Property	Description
Operation Type	The write operation for the JDBC V2 data object.
Pre SQL	The SQL statement to run before writing data to the target.
Post SQL	The SQL statement to run after writing data to the target.
Truncate Target	Truncates the target table before inserting records to the target.
Reject Truncated/Overflow Rows	Writes truncated and overflow data to the reject file. If you select Reject Truncated/Overflow Rows, the Data Integration Service sends all truncated rows and any overflow rows to the reject file.
Table Name	Overrides the table name used in the metadata import with the table name you specify.
Schema Name	Overrides the schema name of the target object. If you specify the schema name both in the connection and the target write operation properties, the Data Integration Service considers the schema name specified in the target write operation properties.
UpdateMode	Not applicable.

Input Properties of the Data Object Write Operation

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.