Column description record

Edit online

One record exists for every column in the associated table record. Each record provides the column name, type, and other characteristics. The order of the column rows is the same order in which the columns are displayed in the output row. However, some columns might be missing on any given row. Use the mapping structure defined under section 3 to determine whether a column is present.

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 format of the column records is described in the following table.

Table 1. Section 2 column description record, exported persistent data
Provides description, offset, length, and type for each field in a Section 2 column description record.
Field	Offset	Length	Type	Description
RecID	0	4	Char	Record ID. Contains DD30 for table record.
Table Ident	4	4	Binary	Identifier for the table this column belongs to.
Column Name	8	10	Char	Column name.
SQL Type	18	2	Char	SQL type for column.
Column Length	20	4	Binary	Maximum length of this column’s data.
Flag	24	1	Binary	Flag byte.
Spare	25	1	---	Unused.
Overlay Col ID	26	2	Char	Column number if this is an overlay.
Overlay Col Off	28	2	Char	Offset into row for start of overlay column.
Alignment	30	2	---	Unused.
Spare 1	32	8	---	Unused.