Suppressing IRDTYPE

In some cases, secondary table records may contain a field that uniquely identifies each different record type.

For example, the extract of the file produced by the VIDLOAD utility shown in Loading the DB2 data shows record types of 10, 20, 30, and 40 in position 1. MULTIRD uses the IRDTYPE parameter to set these record types. The field RECORD-TYPE is at position 9 in these records, and it contains values of 010, 020, 030, and 040.

There is a pair of records for each record type. The first instance corresponds to the record to be loaded to the primary table. The second instance corresponds to the record to be loaded to the secondary table. Without the IRDTYPE parameter in bytes 1 and 2, you are unable to code a WHEN (x:y) = ‘record_type' parameter in the DB2 load utility to distinguish between records for the primary and secondary tables.

When your data already has a field which uniquely identifies it, you can suppress the 2-byte record identifier by specifying IRDTYPE = ??.


Concept Concept

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/cvtdecSuppressingIRDTYPE.html