After Script

String

No

SQL instructions representing the script to be executed in the database after writing is done.

Batch Size

Integer

Yes

Number of elements to be used in the batch. The minimum size for a batch is 10. The maximum batch size is currently limited to 3000 rows. When the commit size is smaller than batchSize then batchSize is set to the value of commitSize.

Before Script

String

No

SQL instructions representing the script to be executed in the database before writing.

Columns

List of Column Expr Def

No

A list of columns to be written to the database. Note that column names should be defined in an "unquoted" form, even if they contain special characters or represents SQL reserved word. Contrary to the tableName property, the column names are quoted automatically as needed.

Commit Size

Integer

Yes

Gives the number of elements after which the commit should be performed. The currently opened batch is executed and the whole current transaction is committed. The commit size is not limited. When set to 0, the whole writing process will be sent as single-commit transaction.

Data Source Name

String

Yes

Name of the DataSource. The DataSource groups together information regarding access to the database, such as:

URL, driver name, username and password.

See the Data Source description for more details.

Error Handler

Error Handler

No

Error handler which defines the behavior of the step in case of writing problems. When this property is set the step has one mandatory output, out_err, where the invalid rows are sent to. The format of this output is the same as that of the input with one additional textual column named as specified by the property errorFieldName, where the cause of problem as reported by the database are written.

Table Name

String

Yes

Name of the table to write data to. This table must exist in the given database and must be writable for the given user.

Note that it is necessary to enclose individual table name parts with quotes when: - given part contains special character(s) (according to the SQL specification) - given part matches SQL reserved word (according to the SQL specification) It's because table name can represent structured value following the catalog.schema.table pattern and therefore it's on the user to specify and quote individual parts when needed.

Example: having catalog 'test:catalog' with schema 'User' and table 'table.1', the correct value is "test:catalog"."User"."table.1" (because both 'table.1' and 'test:catalog' contains special characters and 'User' is an SQL reserved word).

Warning: quoted parts should exactly represent DB object name since many DB's are case sensitive when dealing with quoted names.

Write All Columns

Boolean

Yes

Specifies whether to write out all columns as defined in the input format. This attribute is exclusive to column definitions. If this value is set to on, then there must be no columns defined in the columns element, otherwise an error is reported.

Id

String

No

Step identification string.