Implemented in: | 8.0 |
|---|---|
Normal Library: | LX_DTA |
Database Index
Name | Unique? | Columns |
|---|---|---|
LX_F14_PRIM | Y | X14P_I, X14PFL, X14PLB, X14TYP, X14SEQ |
Record Layout
Key | Name | Description | Type | Comments |
|---|---|---|---|---|
1 | X14P_I | Partition Identifier | CHAR(3) | |
2 | X14PFL | Physical file name | CHAR(10) | |
3 | X14PLB | Library name | CHAR(10) | |
4 | X14TYP | Field type | CHAR(3) | FFD or VFD |
5 | X14SEQ | Sequence number | LONG | |
X14FLD | Field Name | CHAR(10) | ||
X14KSQ | Key sequence number in file | SMALLINT | ||
X14FTP | Field type | CHAR(1) | ||
X14XTP | LANSA/X data type | CHAR(1) | Not used. | |
X14LEN | Field length | LONG | ||
X14DEC | Field number of decimals | SMALLINT | ||
X14SRC | Source of table data | CHAR(3) | e.g. ADW, LMD | |
X14SPI | Spare field | STRING(100) |
X14SP1 Layout
Visual LANSA files have the following additional definitions in X14SP1.
Offset | Description | Type | Default | Comment |
|---|---|---|---|---|
0 | Column Id | Char(10) | Blank | key (pointer) to LX_FCN |
10 | Read Only Column | Char(1) | Blank | 'Y' if column is read-only, otherwise blank or less than 11 characters long. This allows Other File columns to be nominated as read only. DC@F14: Maps to F14AKI position 11 (for type PCF). |
11 | LOB Type | Char(1) | Blank | 'S' if LOB is secure, 'C' if it is cached. Blank or not set defaults to cached. DC@F14: Maps to F14AKI position 11 (for type FFD). |
12 | Identity Column (RDMLX files) | Char(1) | Blank | 'Y' if column is an identity column, otherwise blank or not set. DC@F14: Maps to F14AKI position 12 (for type PCF). For RDML Files, this setting is stored in LX_FCN, SP1, offset 11. |