Column description record
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.
| 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. |