External Source stage: Options section (DataStage®)

Use the Options section to specify how the External Source stage operates.

Keep file partitions

Set the value to True to maintain the partitioning of the read data. Defaults to False.

Reject mode

Set this option to specify behavior if a record fails to be read for some reason. Choose from Continue to continue operation and discard any rejected rows, Fail to cease reading if any rows are rejected, or Save to send rejected rows down a reject link. Defaults to Continue.

Schema file

This property is optional. By default the External Source stage uses the column definitions that are defined in the Columns section and Schema tab as a schema for reading the file. However, you can specify a file that contains a schema instead (note, however, that if you defined columns on the Columns tab, you should ensure these match the schema file). Type in a path name or browse for a schema file.

Source name column

This is an optional property. The property adds an extra column of type VarChar to the output of the stage. The column contains the path name of the source the record is read from. You should also add this column manually to the Columns definitions to ensure that the column is not dropped if you are not using runtime column propagation, or it is turned off at some point.

Row number column

This property is optional. The property adds an extra column of type unsigned BigInt to the output of the stage. The column contains the row number. You must also add the column to the columns tab, unless runtime column propagation is enabled.

Strip BOM

Set this property to TRUE to drop the UTF-16 Endianness byte order mark when data is read. By default, this property is set to FALSE.