Table description record

Each table in the exported data set has a table record that provides its name and identifier, and additional information about the columns. All table records are provided before the first column record. The column records and all of the data records in section 3 use the identifier number to associate it with the appropriate table.

Important: The content in this section was created for and applies to the original persistent data store, referred to as PDS V1. A new PDS version (referred to as PDS V2) now exists. PDS V1 will eventually be deprecated.

The map length and variable column count fields can be used to determine exactly where the data for each column starts and to determine if the column exists in a record. The format of the table description record is described in the table that follows.

Table 1. Section 2 table description record, exported persistent data
Field	Offset	Length	Type	Description
RecID	0	4	Char	Record ID. Contains DD20 for table record.
Identifier Num	4	4	Binary	Unique number for this table.
Application	8	8	Char	Application name table belongs to.
Table Name	16	10	Char	Table name.
Table Version	26	8	Char	Table version.
Map Length	34	2	Binary	Length of the mapping area.
Column Count	16	4	Binary	Count of columns in the table.
Variable Cols	36	4	Binary	Count of variable name columns.
Row Count	40	4	Binary	Number of rows in exported file for this table.
Oldest Row	44	16	Char	Timestamp for oldest row written for this table.
Newest Row	64	16	Char	Timestamp for newest row written for this table.
Expansion	80	16	---	Unused area.