DBMAINT Mode - DATACOM/DB Structure Maintenance › Add Structures › Add KEY Substructures › Define Fields to the Key

Define Fields to the Key

Use the following descriptions when defining the fields that comprise the key. This region contains one line to define one field. To insert additional lines on this panel:

1. Type I (Insert) and the number of lines you want to insert in the line number display one line before where you want the lines inserted.
2. Press Enter. The panel displays the original line, plus the inserted lines without line numbers. For more information, see Line Commands.

Field Name

(Required) Specify the FIELD occurrence name. The FIELD occurrence must already be defined to the TABLE substructure.

For more information, see the KEY-FIELD-NAME attribute-type for KEY occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

1- to 32-character name

Default Value:

(No default)

Order

(Optional) Specify whether CA Datacom/DB is to sequence a simple field in the key in ascending (A) or descending (D) order.

For more information, see the ORDER attribute-type for FIELD and KEY occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

A or D

Default Value:

A

Data-Sensitive

(Optional) Specify Y (yes) for the attribute-value if you want CA Datacom/DB to treat the key as data sensitive during sorting.

You can specify Y only for simple fields with the following data types: B (length 2 or 4), D, E, L, N, S, 2, and 4.

If the KEY is created through SQL, the value defaults to Y.

For more information, see the DATA-SENSITIVE attribute-type for FIELD and KEY occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

N or Y

Default Value:

N

Compiler-Name

(Optional) If your site uses compiler names that are different from the occurrence names, specify the compiler name for the field.

Valid Entries:

1- to 30-character compiler name

Default Value:

(No default)

ASM-Name

(Optional) If your site uses Assembler names that are different from the occurrence names, specify the Assembler name for the field.

Valid Entries:

1- to 8-character Assembler name

Default Value:

(No default)

Press PF9 (APPLY) after completing your entries. If there are no errors, CA Datacom Datadictionary displays the Field Summary Panel with the message confirming successful field maintenance.

If an entry for a field is incorrect, an error code is received in the column to the left of Field Name on the Field Attribute Panel when you press PF9 (APPLY). For more information, see the section on field maintenance error codes in the CA Datacom/DB Message Reference Guide.