Previous Topic: APPLY the FIELD DefinitionsNext Topic: Copy Structures


Define the FIELD Occurrences

The following list describes each attribute, the valid entries, and the default (if one exists). Attributes that require an entry are highlighted on your terminal. Attributes which are not highlighted indicate that an entry is optional. If you do not assign a value to these attributes, they default to the value assigned in CA Datacom Datadictionary. If FIELD occurrences have not been previously defined, CA Datacom Datadictionary presents a FILE Maintenance Panel similar to the following panel:

=> => => 1-DDOL000407I - 03IP - RECORD HAS NO RELATED FIELDS ------------------------------------------------------------------------------- DDOL: ANCHORED OCCURRENCE FOR RECORD FIELD MAINTENANCE TYPE OCCURRENCE STA VER REC PER-REC-HISTORY T 001 ---------------------------------------------------------------------------T03U Level Field-Name DB Element-Name Preci Type Len Repeat Just Rdf Null Fill (Num:Sign Type Dec) ====== == ======== ================== T O P ======= ===== ==================== 000001 1 ________________________________ _____ _____ _ _____ _____ _ _ _ _ _ _ ___ ====== == ======== =============== B O T T O M ==== ===== ====================

When the display is longer than the screen, you can use the scroll commands or PF keys to move backward and forward through the display.

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 this attribute, see the CLASS attribute-type for FIELD occurrences in the CA Datacom Datadictionary Attribute Reference Guide

Note: 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 in Define the FIELD Occurrences).

Valid Entries:

1 Simple 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

Only valid when defining fields to a table. See the DBMAINT Mode.

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, see the PRECISION attribute-type for FIELD occurrences in 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) Specify the type of data stored in the FIELD occurrence. For more information, see the TYPE attribute-type in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

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

Default Value:

C

Len

(Optional) Specify the physical length of the field in bytes. To account for the 2-byte length prefix on variable columns, for VARCHAR (TYPE=V) and VARGRAPHIC (TYPE=W) two (2) is added to the value specified for the physical length. For more information, see the LENGTH attribute-type in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

A 1- to 5-digit value that cannot exceed the maximum record size

Default Value:

1

Repeat

(Optional) Specify if this is a repeating field. For more information, see the REPEAT attribute-type in 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. For more information, see the JUSTIFICATION attribute-type in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

L or 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. For more information, see the REDEFINES attribute-type in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

N, P, or S

Default Value:

N

Null

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

We recommend that you allow this attribute-value to default to N unless you manually maintain the contents of this field.

Valid Entries:

N or Y

Default Value:

N

Fill

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

Valid Entries:

Y

Default Value:

blank

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 with the SIGN attribute-value if the field contains signed numeric data (Y) or unsigned data (N).

Valid Entries:

Y or N

Default Value:

Y

Type

(Optional) If the field is signed numeric, specify the signing convention for the field. See the TYPE-NUMERIC attribute-type in the CA Datacom Datadictionary Attribute Reference Guide for details.

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, see the DECIMALS attribute-type for FIELD occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

Number of decimal positions

Default Value:

0