Id

String

No

Step identification string.

After Script

String

No

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

Before Script

String

No

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

Columns

List of Jdbc Reader Column

Yes

Contains definitions of columns which will be constructed from the JDBC query result set.

Data Source Name

String

Yes

Name of the DataSource. 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.

Query File Encoding

String

No

Encoding of the query file if such a file is used.

Query File Name

String

No

When defined, it represents the name of the file that contains the query to execute. When this attribute is filled in, the attribute queryString must not contain any value, otherwise a query conflict error is reported.

Query String

String

Yes

SQL query to execute on the data source to obtain input data records. Only selection operations are supported.

Shadow Columns

List of Shadow Column Def

No

Contains a set of columns that are not present in the input data, but should be created in the output (so that they are then available for further use as any other "real" column read from a file).