Options

The "Options" screen for a table is shown below:

The following properties are set on the Options screen:

Property:

Description:

Value:

Name

Name of the table.

<Text>

Description

Description of the table.

<Text>

Filegroup/
Tablespace

Name of the MS-SQL filegroup or Oracle tablespace, as is defined by the database administrator.

<Text>

Add timestamp fields

Whether the following readonly fields will be added to the database. Possible values: Default (set in Application Options), Yes and No.

Name:

Type:

Length:

Format:

LIONMODIFIEDDATE

Numeric

yyyymmdd

LIONMODIFIEDTIME

Numeric

hhmmss

LIONCREATEDDATE

Numeric

yyyymmdd

LIONCREATEDTIME

Numeric

hhmmss

These fields are maintained by AMT-COBOL whenever a record is added or modified.

Unicode

Whether the table will use unicode coding. Possible values: Default (set in Application Options), Yes and No.


When exporting Unicode data to ASCII files, non-ASCII characters will be replace by question marks '?'.

Length of Lionrecno

Set LIONRECNO to a Numeric 18 field instead of the default Numeric 9. Possible values: Default (set in Application Options), Numeric 9 and Numeric 18.

When using Numeric 9 on large systems the value may exceed the maximum value of 999.999.999 in due time. Therefore when performing a Reorganization on the database and LIONRECNO in one of the tables exceeds the value 950.000.000 then a warning will be issued stating 'Nearing max value (999999999) of LionRecno. Current <current value>. Please renumber the table'.
When defined as Numeric 18 this warning will not be issued.

Synonym

An alternative name for the table that can be used in queries instead of the table name. Synonyms must be unique throughout the application and database.

<Text>