Click the Insert Options button to open the Insert Options window. By default all attributes will be inserted. Deselect the attributes you want to exclude from insertion. This is useful if, for example, an attribute is automatically defaulted by the database system. You may specify an SQL INSERT value clause for each attribute, overwriting the incoming value of the selected attribute.
The Write Block Size defines the number of records to be written to the database in a single write operation.
This property provides one or more SQL statements to be executed during initialization of the project.
This property provides one or more SQL statements to be executed when all components finished execution.
The open quote character begins the attribute names in SQL statements.
The close quote character ends the attribute names in SQL statements.
See section “Entering database connection parameters”for more information on the previous properties and the following properties:
Database
Schema
Standardize Data Format
Database Options
