Implemented in: | 8.0 |
|---|---|
Normal Library: | LX_DTA |
Database Index
Name | Unique? | Columns |
|---|---|---|
LX_F27_PRIM | Y | X27P_I, X27PFL, X27PLB |
Record Layout
Key | Name | Description | Type | Comments |
|---|---|---|---|---|
1 | X27P_I | Partition Identifier | CHAR(3) | |
2 | X27PFL | Physical file name | CHAR(10) | |
3 | X27PLB | File library | CHAR(10) | |
X27EXF | External file indicator | CHAR(1) | N = LANSA file | |
X27AP1 | Additional parameters part 1 &2 | STRING(400) | ||
X27CMT | Under Commitment Control | CHAR(1) | ||
X27ACP | AUTOCOMMIT option | CHAR(1) | ||
X27SHR | Share an open data path | CHAR(1) | ||
X27DBG | Strip debug information from I/O module | CHAR(1) | ||
X27SEM | Suppress IOM0034 message | CHAR(1) | ||
X27IDE | Ignore decimal data error in RPG I/O module compile | CHAR(1) | ||
X27RFM | Record format name | CHAR(10) | ||
X27SOV | Secure from overrides at a higher level | CHAR(1) | ||
X27IOM | Create an I/O module for this table | CHAR(1) | ||
X27BCH | Create batch control record | CHAR(1) | ||
X27IOL | I/O module library | CHAR(1) | F = file library | |
X27ASQ | Alternate collating label name | CHAR(10) | ||
X27HST | ISeries high speed table | CHAR(1) | ||
X27SPI | Spare field 1 | STRING(100) |
X27SP1 Layout
Visual LANSA files have the following additional definitions in X27SP1.
Offset | Description | Type | Default | Comment |
|---|---|---|---|---|
0 | File compile status | CHAR(1) | 0 | Values 0 to 8 which determines the build status comment in the File control window |
1 | File compile date | CHAR(6) | Blank | |
7 | File compile time | CHAR(6) | Blank | |
13 | Auto RRN | CHAR(1) | Blank | Y/N |
14 | Create RRN column | CHAR(1) | Blank | O = Do not create column |
15 | RDMLX | CHAR(1) | Blank | '1' = RDMLX |
16 | IBM i SQL Settng | CHAR(1) | Blank | File created by SQL |
17 | Convert special characters in LANSA-defined field names | CHAR(1) | Blank | 1 = Field names should be used as-is when creating files. |
18 | Use Database Triggers | CHAR(1) | Blank | Y = Generate DB Trigger, any other value is ignored |
19 | DB Trigger Program Name | CHAR(10) | Blank | |
29 | Not used | |||
30 | Enabled for Long Names | CHAR (1) | Blank | Y=Enabled N or Blank = Disabled If this flag is Y, it takes precedence over the flag in Offset 17. |