A table record follows the header record. Each IXF file, data set, or CICS data queue must have a T record. A table record contains table and data information concerning the file, data set, or CICS data queue being exported using the QMF EXPORT TABLE command. However, when exporting the QMF data object that was the result of a RUN QUERY command, the table record contains a blank owner and name. For long names, the table name is truncated at 18 characters and the owner name is truncated at 8 characters.
The format of a T record is as follows:
Byte position |
Information and type |
---|---|
01 | Table record indicator (T) |
02-03 | Data name length (18) |
04-21 | Name of the table from which data is retrieved-
left-justified, padded with blanks to the right
The entire 18-byte field is blank if the table does not have a name. |
22-29 | Data name qualifier- name of the owner of the
database table from which the data is retrieved
The 8-byte field is blank if the table does not have an owner. |
30-41 | Data source (database) |
42 | Convention used to describe data: C for columnar data |
43 | Data format: C for character (OUTPUTMODE=CHARACTER) M for machine (OUTPUTMODE=BINARY) |
44 | Data location: I for internal |
45-49 | Count of column (C) records- a numeric value in character form specifying the number of C records before the first data (D) record |
50-51 | Reserved |
52-81 | Blanks |