| File Name | DC@FDB, LX_FDB |
|---|---|
| Description | This table stores DBMS-specific settings for Physical files, normal logical files, and columns. |
| Implemented in: | 11 / I3 |
LANSA for i Library: | <<dtalib>> |
| Visual LANSA Collection: | LX_DTA |
| Field Name Prefix | FDB, XDB |
| Required for Run Only System? | No |
LANSA for i Logical Views
Name | Use | Keys/Description/Comments |
|---|---|---|
DC@FDBV1 | Read | FDBP#I, FDBPFL, FDBPLB, FDBDBT, FDBTYP, FDBOBJ, FDBSEQ |
DC@FDBV2 | Update | Same as DC@FDBV1. |
DC@FDBV3 | Read | FDBP#I, FDBOBJ, FDBTYP, FDBSEQ |
DC@FDBV4 | Update | Same as DC@FDBV3. |
Visual LANSA Database Index
Name | Unique? | Columns |
|---|---|---|
LX_FDB_PRIM | Y | XDBP_I, XDBPFL, XDBPLB, XDBDBT, XDBTYP, XDBOBJ, XDBSEQ |
Record Layout
Key | Field Name | Description | LANSA for i Type | Visual LANSA Type | Comments |
|---|---|---|---|---|---|
1 | P_I | Partition Identifier | A 3 | CHAR(3) | |
2 | PFL | PhysicalFile Name | A 10 | CHAR(10) | |
3 | PLB | Physical File Library | A 10 | CHAR(10) | |
4 | DBT | DBMS Type | A 32 | CHAR(32) | As per X_DBMENV.DAT. Blank if affects ALL database types (always blank for TYP = IF). |
5 | TYP | Sub Object type | A 2 | CHAR(2) | PF (Physical File), LF (Normal Logical File), DF (Field), IF (Index logical file)* * Not yet implemented |
6 | OBJ | Sub Object | A 10 | CHAR(10) | Blank if type = PF LogicalFile Name if type = LF or IF* Field name if type = DF *Note: This is the only place these files are defined, so when deciding whether aFile Name is unique, these records must also be checked. |
7 | SEQ | Sequence | P 11,0 | LONG | In case multiple rows are needed to store the data. |
DTA | Data | A 256 | STRING(256) | DBMS Specific Data, or Index-only logical details. |