File Name: | DC@FOF, LX_FOF |
|---|---|
| Description | This table defines a PC Other File or Other SQL View so that it can be located in the External Database. |
| Implemented in: | 8.05 / H9 |
LANSA for i Library: | <<dtalib>> |
| Visual LANSA Collection: | LX_DTA |
| Field Name Prefix: | FOF, XOF |
| Required for Run Only System? | Yes |
Name | Use | Keys/Description/Comments |
|---|---|---|
DC@FOFV1 | Read | FOFP_I, FOFPFL, FOFPLB |
DC@FOFV2 | Update | Same as DC@FOFV1 |
DC@FOFV3 | Read | FOFDSN |
DC@FOFV4 | Update | Same as DC@FOFV3 |
Name | Unique? | Columns |
|---|---|---|
LX_FOF_PRIM | Y | XOFP_I, XOFPFL, XOFPLB |
LX_FOF_I1 | XOFDSN |
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 | File Library | P 7,0 | CHAR(10) | Set to "*OTHER" by LoadOtherFile |
DSN | Data Source Name | CHAR(32) | SQLTables() | ||
QAL | Qualifier | CHAR(128) | SQLTables() | ||
OWN | Owner | CHAR(128) | SQLTables() | ||
NAM | Table Name | CHAR(128) | SQLTables().('*' for tables loaded in version 13.0 or later. Actual name stored in LX_FAN. If entry not found in LX_FAN then table name of '*' is used) | ||
TYP | LANSA Database Type | CHAR(32) | e.g. MSACCESS or ODBCORACLE | ||
CON | Connection Parameters | CHAR(2000) | All the connection parameters that are required to make a successful connection to the database. | ||
CRP | Encrypted Indicator | CHAR(1) | Y if CON is encrypted. | ||
SP1 | Expansion Field 1 | CHAR(255) | Future expansion |
Offset | Description | Type | Default | Comments |
|---|---|---|---|---|
0 | Identifier Quote Character | CHAR(1) | " | This value comes from the value of the ODBC SQL_IDENTIFER_QUOTE_CHAR attribute. |
1 | Read only other file | CHAR(1) | Blank | Y = read only other file |
2 | Add columns to support LOBs | CHAR(1) | Blank | Y = add filename column (and timestamp column if cached LOB) to file for each BLOB or CLOB. |