Navigator User Guide

Back Next

Adding a Key to a Datacom Record

Add one or more keys to a record in a Datacom data map.

To add a key to a Datacom record:

Open the Datacom data map.

On the

Data Map

tab in the

Resource Explorer

, right-click the record and click

Properties

The

Record Properties

dialog box appears.

The following table describes the information that appears for any defined keys on the

Keys

tab in the

Record Properties

dialog box:

Option	Description
Long Key Name	The long name of the key. Maximum length is 32 characters.
Short Key Name	The short name of the key. Maximum length is five characters.

On the

Keys

tab, click the

Add New

toolbar button.

The

Key Properties

dialog box appears.

On the

Key Details

tab, define the key.

The following table describes the information to enter:

Option	Description
Long Key Name	Enter the long name of the key. Maximum length is 32 characters.
Short Key Name	Enter the short name of the key. Maximum length is five characters.
Master Key	Enter the master key for the table. Every table requires a master key. The master key can be the same key as the native key.
Change Allowed	Select this option to allow the master key to be changed. Clear this option to prevent the master key from being changed. If you clear this option, CA Datacom/DB prohibits any change to the value of the master key for a row in the table. Default is cleared.
Unique	Select this option to prohibit duplicate master keys. Default is cleared.
Duplicate Allowed	Select this option to allow duplicate master keys. Default is cleared.
Native	Select this option to define the key as the native sequence key for this table. Every table requires one, and only one, native key, which designates the order in which data is loaded and maintained. The native key represents the order most often used in sequential processing. Default is cleared.
Nillable	Select this option to allow the key to have nil values placed in the index. Nil represents low values or blanks. Default is cleared.
Compound Boolean Selection Allowed	Select this option to allow compound Boolean selection. Default is cleared.