Defining record ID constraints in DataStage®

If you are using the Complex Flat File connector to read data from a file that contains multiple record types, you must specify a record ID constraint to identify the format of each record.

About this task

Columns that are identified in the record ID clause must be in the same physical storage location across records. The constraint must be a simple equality expression, where a column equals a value.

Procedure

  1. Click the Records ID tab on the Stage tab.
  2. Select a column in the Column name field of each record. The list of columns that opens when you click on the field displays all columns from the selected record, except the first OCCURS DEPENDING ON (ODO) column and any columns that follow it.
  3. Type the identifying value for the record ID column in the Value field of each record.
    Character values must be enclosed in single quotation marks.