After Script

String

No

SQL script to execute after step processing is done.

Autocommit

Boolean

Yes

Determines whether commit should be done automatically. The default is false, which means that commit is done after all processing is done or by the batches determined by the commitSize parameter.

Batch Size

Integer

Yes

Determines the size of the batch to use when updating the database. Note that batch size is used only if the query is not a procedure call. Default value: 0 (no batching). Reasonable values start at about 1000.

Before Script

String

No

SQL script to execute before the step is run.

Data Source Name

String

Yes

Data source definition to use.

Query

String

Yes

SQL query to execute. See the detailed step description for information how to define query parameters.

Commit Size

Integer

Yes

Defines after how many statements commit should be invoked. A value of 1 means autocommit.

Id

String

No

Step identification string.