HELP: Read a data field prefixed with a length field TYPE: OBJECT SYNTAX: LFD(LENFMT=L4I/L4X/B4I/B4X/S4I/S4X/HLI/HLX/HBI/HBX/HSI/HSX/L2I/L2X/B2I/B2X/S2I/S2X/S1I/S1X/D1I/D2I/D3I/D4I/D5I/D6I/D7I/D8I/D9I/D0I/D1X/D2X/D3X/D4X/D5X/D6X/D7X/D8X/D9X/D0X,AWLEOD,ALIGN=num)
This object is used to read a column with data that is prefixed with a length field. A limit for the maximum length and/or an alignment of this element can be set for better format detection.
NUMBER: LENFMT=L4I/L4X/B4I/B4X/S4I/S4X/HLI/HLX/HBI/HBX/HSI/HSX/L2I/L2X/B2I/B2X/S2I/S2X/S1I/S1X/D1I/D2I/D3I/D4I/D5I/D6I/D7I/D8I/D9I/D0I/D1X/D2X/D3X/D4X/D5X/D6X/D7X/D8X/D9X/D0X - Format of the length field [S2X (VARCHAR)]
L4I - Parse binary 4 byte length fields: Little endian integer, length inclusiveL4X - Parse binary 4 byte length fields: Little endian integer, length exclusive (ZIP)B4I - Parse binary 4 byte length fields: Big endian integer, length inclusiveB4X - Parse binary 4 byte length fields: Big endian integer, length exclusive (USS)S4I - Parse binary 4 byte length fields: System endian integer, length inclusiveS4X - Parse binary 4 byte length fields: System endian integer, length exclusive (VAR)HLI - Parse binary 4 byte length fields: Little endian short (LLxx), length inclusiveHLX - Parse binary 4 byte length fields: Little endian short (LLxx), length exclusiveHBI - Parse binary 4 byte length fields: Big endian short (LLxx), length inclusive (MVS)HBX - Parse binary 4 byte length fields: Big endian short (LLxx), length exclusiveHSI - Parse binary 4 byte length fields: System endian short (LLxx), length inclusiveHSX - Parse binary 4 byte length fields: System endian short (LLxx), length exclusiveL2I - Parse binary 2 byte length fields: Little endian integer, length inclusiveL2X - Parse binary 2 byte length fields: Little endian integer, length exclusiveB2I - Parse binary 2 byte length fields: Big endian integer, length inclusiveB2X - Parse binary 2 byte length fields: Big endian integer, length exclusiveS2I - Parse binary 2 byte length fields: System endian integer, length inclusiveS2X - Parse binary 2 byte length fields: System endian integer, length exclusive (VARCHAR)S1I - Parse binary 1 byte length fields: Length inclusiveS1X - Parse binary 1 byte length fields: Length exclusiveD1I - Parse decimal 1 byte length fields: Length inclusiveD2I - Parse decimal 2 byte length fields: Length inclusiveD3I - Parse decimal 3 byte length fields: Length inclusiveD4I - Parse decimal 4 byte length fields: Length inclusiveD5I - Parse decimal 5 byte length fields: Length inclusiveD6I - Parse decimal 6 byte length fields: Length inclusiveD7I - Parse decimal 7 byte length fields: Length inclusiveD8I - Parse decimal 8 byte length fields: Length inclusiveD9I - Parse decimal 9 byte length fields: Length inclusiveD0I - Parse decimal 10 byte length fields: Length inclusiveD1X - Parse decimal 1 byte length fields: Length exclusiveD2X - Parse decimal 2 byte length fields: Length exclusiveD3X - Parse decimal 3 byte length fields: Length exclusiveD4X - Parse decimal 4 byte length fields: Length exclusiveD5X - Parse decimal 5 byte length fields: Length exclusiveD6X - Parse decimal 6 byte length fields: Length exclusiveD7X - Parse decimal 7 byte length fields: Length exclusiveD8X - Parse decimal 8 byte length fields: Length exclusiveD9X - Parse decimal 9 byte length fields: Length exclusiveD0X - Parse decimal 10 byte length fields: Length exclusiveSWITCH: AWLEOD - Accept wrong length at the end of a row [OFF]NUMBER: ALIGN=num - Align data to the next multiple of this value in bytes [1 (no alignment)]