DB2 graphic QMF Version 8

Table record (T)

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


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004