File Name:

DC@FCN, LX_FCN

Description

This table defines a column name used in a PC Other File or Other SQL View. It uniquely describes a column so that column changes can be detected. That is, every Field in an Other File uses a record in this table.
For a column name to be the same, the following attributes need to be the same: Column Name, SQL Data Type, Precision, Length, Scale, Radix, Nullable, and IsIdentity. For more information, see the Record Layout.

Most of the information is retrieved from the ODBC API SQLColumns() as commented on in the Record Layout.

Implemented in:

8.05/ H9

LANSA for i Library:

<<dtalib>>

Visual LANSA Collection:

LX_DTA

Field Name Prefix

FCN, XCN

Required for Run Only System?

Yes

Logical Views

Name

Use

Keys/Description/Comments

DC@FCNV1

Read

FCNP#I, FCNPTR

DC@FCNV2

Update

Same as DC@FCNV1.

DC@FCNV3

Read

FCNP#I, FCNCOL

DC@FCNV4

Update

Same as DC@FCNV3.

Record Layout

Key

Field Name

Type

Len

Dec

Description/Comments/Values

1

FCNP_I

A

3


Partition Identifier

2

FCNPTR

A

10


Column ID Pointer
A numeric identifier to uniquely link this column from a particular Field in a File (LX_F14)
Generated from "Unique_Column_Rename_ID" in LX_F95. Key handled in same manner as "Unique_Validation_Pointer_Key" e.g. if LIMPORT contains LX_FCN data, this value must be re-calculated.


FCNCOL

A

128


Column Name
SQLColumns() COLUMN_NAME ('*' for tables loaded in version 13.0 or later. Actual name stored in LX_FAN. If entry not found in LX_FAN then column name of '*' is used)


FCNDTP

P

5


SQL data type
SQLColumns() DATA_TYPE


FCNPRE

P

10

0

Precision
SQLColumns() PRECISION


FCNLEN

P

10

0

Length
SQLColumns() LENGTH


FCNSCL

P

5

0

Scale
SQLColumns() SCALE


FCNRDX

P

5

0

Radix
SQLColumns() RADIX


FCNNUL

P

5

0

Nullable
SQLColumns() NULLABLE


FCNSP1

A

128


Future Expansion - Field 1
Refer to SP1 Layout details following.

SP1 Layout

Offset

LANSA for i Type

Visual LANSA Type

Description/Comments

0

A 9

CHAR(9)

Field Name (without the #)

9

A 1

CHAR(1)

Identity Column for RDML PC Other Files. For RDMLX PC Other Files, this information is stored in DC@F14/LX_F14.

Y if column is recognised as an Identity column by LANSA. Otherwise set to blank. Note: There can only be one Identity column per table (DBMS limitation).

  • No labels