Input_Source_Order_by

For the parameter Input_Source_Type = 'DRDA', 'ODBC', 'EXASOL', 'MYSQL', 'POSTGRESQL' or 'ORACLE':

The parameter Input_Source_Order_by defines the field names and sequences of an SQL query that represent the ascending and unique sorting values. The fields must be separated by commas.

The parameter value is a character string.

Example:

Input_Order_by = 'Number, Name'

This parameter is mandatory for Input_Type = 'BATCH_COMPARE' and must be specified.

This parameter is optional for Input_Type = 'BULK_TRANSFER' if the output file should be used by a subsequent 'BATCH_COMPARE' script.

For Input_Source_Type = 'DATACOM' and Input_Type = 'BATCH_COMPARE':

The parameter Input_Source_Order_by defines positions and lengths of fields that are the ascending and unique sort values. The field names must be separated by commas.

The parameter value is a character string.

Example:

Input_Order_by = '0(1),10(1),22(2),34(2)'

This parameter is mandatory for Input_Type = 'BATCH_COMPARE'.