Add FIELD Occurrences

ENTMAINT Mode - Entity Maintenance › Update Occurrences › Anchored Occurrence for Record/Table Field Maintenance Panel › Add FIELD Occurrences

Add FIELD Occurrences

To insert additional lines on this panel:

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

The FIELD definition region includes two lines of attributes for each occurrence. The attributes are described next.

 -----------------------------------------------------------------------------
           Level    Field-Name                       DB Element-Name
           Preci    Type  Len    Repeat  Just Rdf Null Fill (Num:Sign Type Dec)
 ====== == ======== ================== T O P ======= ===== ====================

 000001    1        ORD-ID
           00005    N     00005  00001   R    N   N              Y    C    000

First Line of Attributes

The following attributes are on the first line of attributes for each FIELD occurrence.

Level

(Required) Specify the level of the FIELD occurrence. CA Datacom Datadictionary uses your entry to assign the CLASS attribute-value of the field.

For more information about entering values in this field. see the CLASS attribute-type for FIELD occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Note: SQL statements can access simple fields only. A simple field is any field that is not the parent of a subordinate level of fields, a value field, an index field, or a filler field (see Fill Add FIELD Occurrences).

Valid Entries:: 1 Simple field or Compound field
2—99 Occurrence level within a compound field
V Value field
I Index field
Default Value:: (No default)

Field-Name

(Required) Specify the CA Datacom Datadictionary name of the FIELD occurrence.

Valid Entries:: 1- to 32-character occurrence name
Default Value:: (No default)

DB Element-Name

(Optional) Specify a DATACOM name to create an element which contains only this field. You can use this attribute only when you initially define the FIELD occurrences for a table. For more information about the DATACOM-NAME attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: 1-5 characters
Default Value:: (No default)

Second Line of Attributes

The following attributes are on the second line of attributes for each FIELD occurrence.

Preci

(Required) Specify the maximum number of displayable digits allowed for data stored in fields whose TYPE is D (decimal), G (graphic), N (numeric), V (varchar), or W (vargraphic).

For more information about the PRECISION attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: 5 characters
Default Value:: D = 2x LENGTH minus 1
G = LENGTH
N = LENGTH
V = LENGTH minus 2
W = (LENGTH minus 2) divided by 2

Type

(Optional) Identify the type of data stored in the FIELD occurrence. There are special considerations for attributes if you are using SQL. For more information about, the TYPE attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: B, C, D, E, G, H, K, L, N, S, T, V, W, Y, Z, 2, 4, or 8
Default Value:: C

Len

(Optional) Specify the physical length in bytes of the field. For more information about the LENGTH attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: 1-5 digits
Default Value:: 1

Repeat

(Optional) Specify if this is a repeating field.

During SQL processing, repeating fields are handled as one large character field. For more information about the, REPEAT attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: Number of repetitions
Default Value:: 1

Just

(Optional) This attribute-value specifies if the data is stored left (L) or right (R) justified.

If you are defining a TABLE substructure for SQL processing, always use the default value. For more information about the JUSTIFICATION attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: L, R
Default Value:: L (left) for Types C, G, H, K, T, V, W, Y, and Z
R (right) for Types B, D, E, L, N, S, 2, 4, and 8

Rdf

(Optional) Specify if this field redefines another field.

Redefines cannot be accessed with SQL processing. For more information about the REDEFINES attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: N, P, or S
Default Value:: N

Null

(Optional) Specify if a 1-byte null indicator is to precede this field. The null indicator can create extra slack if the fields are aligned.

For more information about the NULL-INDICATOR attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: Y or N
Default Value:: N

Fill

(Optional) Specify if the field is a filler field. If you enter Y (yes), CA Datacom Datadictionary assigns F as the attribute-value of the CLASS attribute-type. If the FIELD occurrence is not a filler, leave this attribute-type blank.

Valid Entries:: Y
Default Value:: (No default)

The three attributes following NUM: within the parentheses are for numeric fields (types B, D, E, L, N, S, 2, 4, or 8). Leave these attributes blank if the field type is not numeric.

Sign

(Optional) Specify if the field contains signed numeric data (Y) or unsigned data (N). For more information about the SIGN attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: Y or N
Default Value:: Y

Type

(Optional) If the field is signed numeric, specify the signing convention for the field.

For more information about the TYPE-NUMERIC attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: C Conventional
P Conventional, always positive
U Unconventional
Q Unconventional, always positive
Default Value:: C

Dec

(Optional) Specify the number of decimal positions for a numeric field with an implied decimal point.

For more information about the DECIMALS attribute-type for FIELD occurrences, see the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: Number of decimal positions
Default Value:: 0