3.2.1 Column Name

Mandatory.

Specify the name of a column that is to be included in the table definition.

Rules

• A column used in a table definition must be defined in the LANSA Repository.

• Note: If the "Multi-add columns" interface is being used to add columns to the table, new fields may be created in the repository. Refer to Column Name Definition.

Tips & Techniques

• LANSA automatically includes one column into every table it creates. The column is called 3.8 The @@UPID Column in LANSA Created Tables and is used by the LANSA database OAMs to check for 'crossed updates'. Although this column is defined in the LANSA Repository it should NEVER be manually included into a table definition. The column does not appear in the list of columns in the table but will appear in the physical database definition.

• The allowed column types in a table are determined by the partition settings. For more details, refer to  RDML and RDMLX Partition Concepts in the Administrator Guide.

Also See

3.2.3 Column Key Position

3.2.2 Column Sequence