Defining Basic Attributes of Fields

#### Search Results

Search

# Defining Basic Attributes of Fields

The functions Add Field and Modify Field can also be called from within the function Edit elements of a File with the editor line command .E. See the section Editors in Predict in the Predict Reference documentation.

This document covers the following topics:

- Add/Copy/Modify Screen

- Field Type

- Level Number

- Field Format

- Character Set

- Character Set - Adabas

- Field Length

- Descriptor Type

- Descriptor Type - continued

- Maximum Number of Values / Occurrences

- Unique Option

- Field Short Name

- Suppression / Null Value Option

- Variable Length Option - IMS

- Null Default Option

- Natural Field Length

- Do Not Convert Option

- Related Standard File

- Check against standard

- Natural Attributes

- Hidden

- Additional attributes / Associations

Most attributes are applicable to fields of all file types.

Basic attributes applying to different field types are described below. Type-specific attributes are described in the section Defining Derived Fields.

## Add/Copy/Modify Screen

The following screen is displayed for the functions Add/Copy/Modify Field.

    13:29:09             *****  P R E D I C T  *****                     2009-07-31
                                  - Add a Field -
    Field ID ........ HNO-EL-A
    File ID ......... HNO-FI-A
    Keys ..                                                                 Zoom: N

    Ty L Field ID                         F Cs Length   Occ   D U DB S NAT-l Cnv
    *- - -------------------------------- *- * -------- ----- * * -- * ----- ---
       1 HNO-EL-A                                                 AA N

    Natural attributes
      Header1 ..................
      Header2 ..................
      Header3 ..................
      Index on PE group level ..           Dynamic length .....
      Edit mask ........
    Abstract     Zoom: N

      Additional attributes ..* N          Associations ..* N

The screen for maintaining fields of SQL file types contains some different attributes and is shown below.

### Possible Types of Fields

The table below lists all possible types of the object type field.

A | Adabas (with parameter Adabas SQL usage set to Y)
AT | Adabas Cluster Table
B | Adabas SQL view
BT, BV | Adabas D table/view
D, E, IT, IV, MT | DB2 table/view, Intermediate table/view, DB2 query table
OT, OV | Oracle table/view
JT, JV | Ingres table/view
X | General SQL file
XT, XV | Informix table/view
YT, YV | Sybase table/view

### Add/Copy/Modify Screen for SQL Fields

The following screen is displayed for the functions Add/Copy/Modify Field and applies to SQL file types.

     17:11:27             *****  P R E D I C T  *****                     2009-07-31
                                   - Add a Field -
     Field ID ........ XYZ_EL_S
     File ID ......... XYZ-DB2
     Keys ..                                                                 Zoom: N

     Ty L Field ID                         F Cs Length   Occ   D U N Df NAT-l
     *- - -------------------------------- *- * -------- ----- * * * *- -----
        1 XYZ_EL_S                                                 U

     Natural attributes
       Header1 ....
       Header2 ....
       Header3 ....
       Edit mask ..
     Hidden .......   (Y/N)
     Abstract     Zoom: N

       Additional attributes ..* N          Associations ..* N

## Field Type

The field type is indicated in the column Ty of the Add/Copy/Modify screen. The following types can be specified:

CM | Counter Field for multiple value field of type MU/MC
CP | Counter Field for periodic group of type PE/PC
DV | Derived field (SQL File types) see note below
GR | Group
HM | Hyperdescriptor as a multiple value field
HP | Hyperdescriptor as a field of a periodic group
HQ | Hyperdescriptor as a multiple value field of a periodic group
HY | Hyperdescriptor
MC | Multiple value field with automatic counter
MD | Indicator for union view. Can be set in the subquery editor only. MD indicates from which fields of the selected master file(s) the union, except or intersect view is created. See Editing the Subquery of an SQL View.
MU | Multiple value field
OD | Collation descriptor
PC | Periodic group with automatic counter
PE | Periodic group
PH | Phonetic descriptor
QN | SEQNO field
SB | Subfield/descriptor
SP | Superfield/descriptor
**,/* | Comment line, see Edit List of Fields - Code L
blank | None of the above. Normal field

Note
Derived field is also used in Predict as a generic term for hyperdescriptors, phonetic descriptors and sub/superfields and descriptors.

If HM, HP, HQ, HY, OD, PH, SB or SP is specified, an additional input screen is displayed. See Defining Derived Fields.

See also section ADACMP (COMPRESS-DECOMPRESS) in the Adabas Utilities documentation.

### Redefining Fields

See Redefine Field - Code R.

### Defining Periodic Groups in Periodic Groups

- Within a redefinition, nested periodic groups (PE within a PE) can be defined in files of all types.

- Outside of a redefinition, nested periodic groups can only be defined in files of the following types:

  S | Sequential file
  C | Conceptual file
  M | ISAM file
  Z | Standard file
  O | Other file

## Level Number

The level number of the field is indicated in the column L of the Add/Copy/Modify screen. The level number is used to define a group structure. Level numbers 1 to 9 can be used (except for Adabas files, see below).

- The level number must be increment by 1 immediately following a field of type RE, PE, PC or GR.

- For redefinitions, the level number must be at least one greater than the level number of the field being redefined. See Redefine Field - Code R.

### Adabas Files

The following rules apply to level numbers for Adabas files:

- The PE/PC-groups, sub/superfields/descriptors, hyperdescriptors and phonetic descriptors must be at level 1.

- Level numbers of fields outside a redefinition must be in the range 1 - 7. See the section ADACMP (COMPRESS-DECOMPRESS) of the Adabas Utilities documentation for a complete description of Adabas levels.

## Field Format

The format of the field is indicated in the column F of the Add/Copy/Modify screen. One of the following values can be specified (depending on the file type):

A | Alphanumeric | IV | Interval
AL | Long varchar | L | Logical
AV | Varchar | LO | Large object
B | Binary/char for bit data | LX | Bfile
BL | Long varchar bit data | MO | Money
BT | Bit | MS | Smallmoney
BV | Varchar for bit data | N/U | Numeric unpacked
D | Date | NS/US | Numeric unpacked with sign
DS | Smalldatetime | OK | Object key
DT | Datetime | P | Packed numeric
F | Floating point | PS | Packed numeric with sign
FD | Decimal floating point | S | Serial
G | Graphic | T | Time
GL | Long vargraphic | TK | Table key
GV | Vargraphic | TS | Timestamp
I | Integer | blank | Undefined

See tables in the section Field Length for valid combinations of format and length.

The following rules apply:

- Any format/length combination is allowed for the file types C (conceptual) or Z (standard).

- For groups, this attribute must be blank.

- For sub/superfields/descriptors in Adabas files, the appropriate format is provided by Predict based on the formats of the fields used. See Rules Applying to Format Changes.

- The following formats are valid for fields within a redefinition: A, B, D, F, I, L, N/U, NS/US, P, PS, T.

## Character Set

The parameter Character set determines the format in which data is stored. It is indicated in column Cs of the Add/Copy/Modify screen. The possible values depend on the file type and format.

File Type | Format | Character Set
--- | --- | ---
ASCII | EBCDIC | Bitdata | Single Byte | Double Byte | Mixed Data | XML
Adabas | A, AV, LO |  |  |  |  | Y |  | Y |
Adabas D | A, AL, AV |  | Y | Y | Y |  |  |  |
DB2 | A, AL, AV |  |  |  | Y | Y |  | Y |
LO |  |  |  | Y | Y | Y | Y | Y
Oracle | A, AL |  |  |  | Y |  |  |  |
AV |  |  |  |  |  |  | Y |
LO |  |  |  | Y |  |  | Y |
Informix | A, AV |  |  |  |  |  |  | Y |
AL |  |  |  | Y |  |  |  |
Ingres | A,AV |  |  |  | Y |  |  |  |
AL | * |  |  | Y |  |  |  |
Sybase | A, AV | * |  |  | Y | Y | Y |  |
AL |  |  |  | Y |  |  |  |

Note
A value must be specified for field types and formats marked with an asterisk (*).

Character Set
ASCII | Data is stored in ASCII format.
EBCDIC | Data is stored in EBCDIC format.
Bitdata | Data is stored in binary form, no conversion is performed.
Single Byte | Data is stored in single-byte format. Double-byte characters are not possible.
Double Byte | Data is stored in double-byte format. String comparisons function differently to single-byte data.
Mixed Data | Data is stored in single and double-bytes. Data is subject to DB2 rules for multiple-byte character sets.
XML | Data is stored in XML format.

## Character Set - Adabas

The following character set is used to define wide character fields.

Adabas | Predict
--- | ---
Format | Option | Format | Character Set
A |  | A | blank or single
W |  | A | Mixed
A | LA | AV | blank or single
W | LA | AV | Mixed
A | LB, L4 | LO | blank or single
W | LB, L4 | LO | Mixed

Note
Option L4 applies to Adabas on Open Systems Version 5 or above only.

## Field Length

The field length is indicated in column Length of the Add/Copy/Modify screen. This length is independent of its internal representation. When generating external objects, the field length is adjusted according to the internal representation of data used by the data storage system. For example: a field which is documented with length P9 is implemented with length P5 by the Adabas LOADER utility and the Adabas nucleus.

### Table of Field Formats and Lengths

The table on the following pages contains the valid format/length combinations for fields of the following file types:

Column | File Type
--- | ---
A / U | Adabas file / userview
A(SQL) / AT / B | Adabas file with SQL usage, Adabas cluster table, Adabas SQL view
BT / BV | Adabas D table / view
D / E / IT / IV / MT | DB2 table / view / Intermediate table / view / DB2 query table
F | rdb file
I / J / K | IMS segment / segment layout / userview
JT / JV | Ingres table / view
L / R / V / W | Logical VSAM file / view / Physical VSAM file / view
M | ISAM file
O | Other
OT / OV | Oracle table / view
P / Q | Entire System Server file / userview
S | Sequential file
T | RMS file
X | General SQL file
XT / XV | Informix table / view
YT / YV | Sybase table / view

Note
The tables do not contain the file types C (conceptual) and Z (standard). For these file types, any format/length combinations are allowed.

#### Key for the following table

no length | Format is valid; length must not be specified.
no restr. | No restrictions: any length may be specified.
p.q (m/n) |
p | number of places before the decimal point
q | number of places after the decimal point
Where:
0 <= p <= m
0 <= q <= n
1 <= p+q <= m
n.m - n2.m2 | Range of places before and after the decimal point. For example, fields of format MO for Sybase tables and views can have up to 15 places before the decimal point and up to 4 places after the decimal point (1.0 - 15.04).
*1 | 0 means 2GB
*2 | 0 means 4GB

Field Format | A, U | A(SQL) AT, B | BT, BV | D, E, IT, IV, MT | F | I, J, K | JT, JV | L, R, V, W | M
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
A | 1-253 | 1-253 | 1-4000 | 1-254 | 1-253 | 1-253 | 1-2000 | 1-253 | no restr.
AL |  |  | 0-99999 *1 | 1-99999 |  |  | 0-99999 *1 |  |
AV | 1-16381 | 1-32767 | 1-4000 | 1-32767 |  |  | 1-2000 |  |
B | 1-126 | 1-126 |  | 1-255 | 1-126 | 1-126 | 1-2000 | 1-126 | no restr.
BL |  |  |  |  |  |  | 0-99999 *1 |  |
BT |  |  |  |  |  |  |  |  |
BV |  |  |  | 1- 32704 |  |  | 1-2000 |  |
D | no length | no length | no length | no length | no length | no length |  | no length | no length
DS |  |  |  |  |  |  |  |  |
DT |  |  |  |  |  |  | no length |  |
F | 4 / 8 | 4 / 8 | 4 / 8 | 4 / 8 |  | 4 / 8 | 4 / 8 | 4 / 8 | 4 / 8
FD |  |  |  | 9 / 17 |  |  |  |  |
G |  |  |  | 1-127 |  |  |  |  |
GL |  |  |  | 1-16383 |  |  |  |  |
GV |  |  |  | 1-16383 |  |  |  |  |
I | 1 / 2 / 4 / 8 | 1 / 2 / 4 / 8 | 2 / 4 | 2 / 4 / 8 | 1 / 2 / 4 / 8 | 1 / 2 / 4 / 8 | 1 / 2 / 4 | 1 / 2 / 4 / 8 | 1 / 2 / 4 / 8
ID |  |  |  |  |  |  |  |  |
IV |  |  |  |  |  |  |  |  |
IY |  |  |  |  |  |  |  |  |
L | no length |  | no length |  |  | no length |  | no length | no length
LO | up to 2 GB |  |  | up to 2 GB |  |  |  |  |
LX |  |  |  |  |  |  |  |  |
MO |  |  |  |  |  |  | no length |  |
MS |  |  |  |  |  |  |  |  |
N | p.q (29/29) | p.q (29/29) |  |  | p.q (29/29) | p.q (29/29) |  | p.q (29/29) | p.q (29/29)
NS | p.q (29/29) | p.q (29/29) | p.q (18/18) | p.q (31/31) | p.q (29/29) | p.q (29/29) |  | p.q (29/29) | p.q (29/29)
OK |  |  |  |  |  |  | no length |  |
P | p.q (29/29) | p.q (29/29) |  |  | p.q (29/29) | p.q (29/29) |  | p.q (29/29) | p.q (29/29)
PS | p.q (29/29) | p.q (29/29) | p.q (18/18) | p.q (31/31) | p.q (29/29) | p.q (29/29) |  | p.q (29/29) | p.q (29/29)
S |  |  |  |  |  |  |  |  |
T | no length | no length | no length | no length | no length | no length |  | no length | no length
TK |  |  |  |  |  |  | no length |  |
TS |  |  | no length | no length |  |  |  |  |
U | p.q (29/29) | p.q (29/29) |  |  | p.q (29/29) | p.q (29/29) |  | p.q (29/29) | p.q (29/29)
US | p.q (29/29) | p.q (29/29) | p.q (18/18) | p.q (31/31) | p.q (29/29) | p.q (29/29) |  | p.q (29/29) | p.q (29/29)

Field Format | O | OT, OV | P, Q | S | T | X | XT, XV | YT, YV
--- | --- | --- | --- | --- | --- | --- | --- | ---
A | no restr. | 1-2000 | no restr. | no restr. | 1-253 | 1-253 | 1-32762 | 1-255
AL |  | 0-99999 *1 |  |  |  |  | 0-99999 *1 | 0-99999 *1
AV |  | 1-2000 |  |  |  |  | 1-32762 | 1-255
B |  |  |  |  |  |  |  |
BL | no restr. |  | 1-126 | no restr. | 1-126 |  |  | 1
BT |  |  |  |  |  |  |  |
BV |  |  |  |  |  |  |  | no length
D | no length |  | no length | no length | no length |  | no length |
DS |  |  |  |  |  |  |  | no length
DT |  | no length |  |  |  |  | no length | no length
F | 4 / 8 | 4 / 8 | 4 / 8 | 4 / 8 |  | 4 / 8 | 4 / 8 | 4 / 8
FD |  |  |  |  |  |  |  |
G |  |  |  |  |  |  |  |
GL |  |  |  |  |  |  |  |
GV |  |  |  |  |  |  |  |
I | 1 / 2 / 4 / 8 | 2 / 4 | 1 / 2 / 4 / 8 | 1 / 2 / 4 / 8 | 1 / 2 / 4 / 8 | 1 / 2 / 4 / 8 | 2 / 4 | 1 / 2 / 4
ID |  |  |  |  |  |  |  |
IV |  |  |  |  |  |  | 7 / 17 |
IY |  |  |  |  |  |  |  |
L | no length |  | no length | no length |  |  |  |
LO |  | 0-99999 *2 |  |  |  |  |  |
LX |  | 0-99999 *2 |  |  |  |  |  |
MO |  |  |  |  |  |  | p.q (32767/99) | 1.0 - 15.04
MS |  |  |  |  |  |  |  | 1.0 - 6.04
N | p.q (29/29) |  | p.q (29/29) | p.q (29/29) | p.q (29/29) | p.q (32/32) |  | p.q (38/38)
NS | p.q (29/29) | p.q (29/29) | p.q (29/29) | p.q (29/29) | p.q (29/29) |  | p.q (32/32) |
OK |  |  |  |  |  |  |  |
P | p.q (29/29) |  | p.q (29/29) | p.q (29/29) | p.q (29/29) | p.q (32/32) |  |
PS | p.q (29/29) | p.q (29/29) | p.q (29/29) | p.q (29/29) | p.q (29/29) |  | p.q (32/32) |
S |  |  |  |  |  |  | no length |
T | no length |  | no length | no length | no length |  |  |
TK |  |  |  |  |  |  |  |
TS |  | no length |  |  |  |  |  | no length
U | p.q (29/29) |  | p.q (29/29) | p.q (29/29) | p.q (29/29) | p.q (32/32) |  |
US | p.q (29/29) | p.q (29/29) | p.q (29/29) | p.q (29/29) | p.q (29/29) |  | p.q (32/32) |

Field Format | 1 | 2
--- | --- | ---
A | 1-253 | 1-253
AL |  |
AV |  |
B |  |
BL | 1-126 | 1-126
BT |  |
BV |  |
D | no length | no length
DS |  |
DT |  |
F | 4 / 8 | 4 / 8
FD |  |
G |  |
GL |  |
GV |  |
I | 1 / 2 / 4 / 8 | 1 / 2 / 4 / 8
ID |  |
IV |  |
IY |  |
L | no length | no length
LO |  |
LX |  |
MO |  |
MS |  |
N | p.q (29/29) | p.q (29/29)
NS | p.q (29/29) | p.q (29/29)
OK |  |
P | p.q (29/29) | p.q (29/29)
PS | p.q (29/29) | p.q (29/29)
S |  |
T | no length | no length
TK |  |
TS |  |
U | p.q (29/29) | p.q (29/29)
US | p.q (29/29) | p.q (29/29)

Note
For format LO the length can be specified in units of KB, MB or GB. Enter the desired value followed by the corresponding character (K for KB, M for MB and G for GB). For limitations refer to the above tables.

### SQL: DBMS Format and Corresponding Predict Format

The table below indicates the DBMS format and the corresponding Predict format for fields in files of the following types:

BT, BV | Adabas D table/view
JT, JV | Ingres table/view
OT, OV | Oracle table/view
XT, XV | Informix table/view
YT, YV | Sybase table/view

#### Key for the following table

n | length
p,q |
p | total number of places
q | number of places after the decimal point

File Type | DBMS Format | Predict Format | Character Set
--- | --- | --- | ---
BT, BV | BOOLEAN | L |
CHAR(n) | A(n) |
CHAR(n) ASCII | A(n) | ASCII
CHAR(n) BYTE | A(n) | Bitdata
CHAR(n) EBCDIC | A(n) | EBCDIC
DATE | D |
FIXED(p,q) | NU, US, or PS |
FLOAT(15) | F4 |
FLOAT(18) | F8 |
INTEGER | I4 |
LONG | AL |
LONG ASCII | AL | ASCII
LONG BYTE | AL | Bitdata
LONG EBCDIC | AL | EBCDIC
SMALLINT | I2 |
TIME | T |
TIMESTAMP | TS |
VARCHAR(n) | AV(n) |
VARCHAR(n) ASCII | AV(n) | ASCII
VARCHAR(n) BYTE | AV(n) | Bitdata
VARCHAR(n) EBCDIC | AV(n) | EBCDIC
JT, JV | BYTE(n) | B |
BYTE VARYING | BV |
C(n) | A(n) |
CHAR(n) | A(n) | Bitdata
DATE | DT |
DECIMAL (p,q) | PS |
DECIMAL (p,q) | NS |
DOUBLE PRECISION | F8 |
LONG BYTE | BL |
LONG VARCHAR | AL | Bitdata
INTEGER | I4 |
INTEGER1 | I1 |
MONEY | MO |
OBJECT_KEY | OK |
REAL | F4 |
SMALLINT | I2 |
TABLE_KEY | TK |
TEXT(n) | AV(n) |
VARCHAR(n) | AV(n) | Bitdata
OT, OV | BFILE | LX |
BLOB | LO | Bitdata
CHAR(n) | A(n) |
CLOB | LO |
DATE | DT |
DECIMAL(p,q) | NS |
DECIMAL(p,q) | PS |
DOUBLE PRECISION | F8 |
INTEGER | I4 |
INTERVAL DAY | ID |
INTERVAL YEAR | IY |
LONG | AL |
LONG RAW | AL | Bitdata
NCLOB | LO | Mixed data
NVARCHAR2(n) | AV(n) | Mixed data
RAW(n) | A(n) | Bitdata
REAL | F4 |
ROWID | A and type QN |
SMALLINT | I2 |
TIMESTAMP | TS |
VARCHAR2(n) | AV(n) |
XT, XV | BYTE | AL | Bitdata
CHAR(n) | A(n) |
DATE | D |
DATETIME YEAR TO FRACTION(5) | DT |
DECIMAL(p,q) | NS |
DECIMAL(p,q) | PS |
FLOAT | F8 |
INTEGER | I4 |
INTERVAL DAY TO FRACTION(5) | IV |
MONEY | MO |
NCHAR(n) | A(n) | Mixed data
NVARCHAR(n) | AV(n) | Mixed data
REAL | F4 |
SERIAL | S |
SMALLINT | I2 |
TEXT | AL |
VARCHAR(n) | AV(n) |
YT, YV | BINARY(N) | A(n) | Bitdata
BIT | BT |
CHAR(N) | A(n) | Single byte
DATETIME | DT |
FLOAT | F8 |
IMAGE | AL | Bitdata
INT | I4 |
MONEY | MO |
NCHAR(N) | A(n) | Double byte
NUMERIC, DECIMAL (p,q) | NS |
NUMERIC, DECIMAL (p,q) | PS |
NVARCHAR(N) | AV(n) | Double byte
REAL | F4 |
SMALLDATETIME | DS |
SMALLINT | I2 |
SMALLMONEY | MS |
TEXT | AL |
TIMESTAMP | TS |
TINYINT | I1 or B1 |
VARBINARY(N) | AV(n) | Bitdata
VARCHAR(N) | AV(n) | Single byte

## Descriptor Type

The descriptor type is indicated in column D of the Add/Copy/Modify screen. The possible values are given in this and the following table.

#### Additional Information on Descriptor Fields

Descriptor fields can be of various types and control which fields can be used in search criteria (for example in Natural `FIND`, `READ` or `HISTOGRAM` statements). Natural programs can only read Adabas files using fields that are defined as a descriptor (usually type D). It should be part of the design to decide which fields are going to be descriptors, superdescriptors etc.

Adabas however, has a feature where a file can be read using any field - regardless of whether it is a descriptor or not. This is called a non-descriptor search. For large data volumes, this can be very slow. This is because there are no indexes built for non-descriptor fields and a physical scan of the data is required. Despite, if there are only a few records, and it is understood that a physical file scan is taking place, then it can be useful on some occasions.

By putting N into the descriptor type in a DDM, Natural programs are allowed to use this field as a non-descriptor search field. That way you can control in the DDM which fields are allowed to be searched on.

The various descriptor types are documented in more detail in Columns of Field Attributes in the section Using the DDM Editor of the Natural Editors documentation.

Code | Description | File Type
--- | --- | ---
A, U | AT, B, A(SQL) | M | O | F | S | T | IV, D, E, MT | C | I, J, K | P, Q
D | Descriptor/Index | Y | Y | Y | Y | Y | Y | Y | Y | Y |  | Y
Disallow |  |  |  |  |  |  |  |  |  |  |
A | Alternate index |  |  |  |  |  |  |  |  | Y | Y |
N | Not inverted | Y | Y | Y | Y | Y | Y | Y | Y | Y |  |
Search field |  |  |  |  |  |  |  |  |  | Y |
P | Primary Index |  | Y |  |  |  |  |  | Y | Y |  |
Q | Sequence |  |  |  |  |  |  |  |  | Y | Y |
E | Foreign key |  | Y |  |  |  |  |  | Y | Y |  |
F | Foreign index |  | Y |  |  |  |  |  | Y | Y |  |
Force |  |  |  |  |  |  |  |  |  |  |
K | Common Key |  |  |  |  |  |  |  |  |  |  |
blank | No descriptor | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
None |  |  |  |  |  |  |  |  |  |  |

## Descriptor Type - continued

Code | Description | File Type
--- | --- | ---
Z | 1 | 2 | L, R, V, W | X | BT, BV | OT, OV | JT, JV | YT, YV | XT, XV
D | Descriptor/Index |  |  |  |  |  |  | Y |  |  |
Disallow | Y |  |  |  |  |  |  |  |  |
A | Alternate index |  | Y | Y | Y |  |  |  |  |  |
N | Not inverted |  |  |  |  | Y | Y | Y | Y | Y | Y
Search field |  |  |  |  |  |  |  |  |  |
P | Primary Index |  | Y | Y | Y | Y | Y | Y | Y | Y | Y
Q | Sequence |  |  |  |  |  |  |  |  |  |
E | Foreign key |  |  |  |  | Y | Y | Y | Y | Y | Y
F | Foreign index |  |  |  |  |  |  | Y |  |  |
Force | Y |  |  |  |  |  |  |  |  |
K | Common Key |  |  |  |  |  |  |  |  | Y |
blank | No descriptor |  | Y | Y | Y | Y | Y | Y | Y | Y | Y
None | Y |  |  |  |  |  |  |  |  |

The following rules apply:

- In an Adabas file, the descriptor must be D if type HM, HP, HQ, HY (all hyperdescriptors), OD (collation descriptor) or PH (phonetic descriptor) is specified.

- For a subdescriptor in an Adabas file, descriptor D and type SB (subfield) must be specified.

- For a superdescriptor in an Adabas file, descriptor D and type SP (superfield) must be specified.

- In a DB2 table, DB2 query table or Oracle table, if a key, partitioning key, cluster column or index (descriptor D, E, F or P) includes more than one field, the type SP (superfield) must be specified

- In a VSAM file or userview (type L, R, V or W), the descriptor must be either P or A if type SP (superfield) is specified.

- If A is specified for a field of a VSAM file (type L or V), an additional screen is displayed for entering the required definitions (see below).

- Descriptor type must be blank for fields within a redefinition.

## Maximum Number of Values / Occurrences

Maximum number of values for a multiple value field or occurrences of a periodic group is indicated in the Occ column of the Add/Copy/Modify screen. This parameter must be specified for multiple value fields and for periodic groups in a redefinition.

Field | Occurrences in range
--- | ---
Within a redefinition | 1- 99999
Outside a redefinition | 1 - 65535

When generating Copy Code, the value specified is used as the default for generating the specifications of MU/MC or PE/PC fields in a format buffer and/or record buffer.

When generating ADACMP/ADAFDU definitions, the Occ parameter is evaluated. If Occ is specified, the number of occurrences of each input data record is constant.

If Occ is not specified, the number of occurrences is taken from a counter field preceding a MU/MC or PE/PC field.

See also the section ADACMP (COMPRESS-DECOMPRESS) in the Adabas Utilities documentation.

Note
For fields of type QN, the Occ column is used to identify either the table level or an individual occurrence of a multiple value field or periodic group.

## Unique Option

The unique option is indicated in column U of the Add/Copy/Modify screen. For groups, this attribute must be blank; for other fields, one of the following values can be specified:

U | Unique.
X | Used for unique descriptors in PE to exclude the occurrence (index) number from the definition of uniqueness.
blank | Not unique.

Unique option must be blank for fields within a redefinition.

## Field Short Name

For file types listed below, the field short name is indicated in the column DB of the Add/Copy/Modify screen. This two-character short name must be defined for the following file types:

A | Adabas file | L | Logical VSAM file
AT | Adabas cluster table | R | Logical VSAM view
I | IMS segment | U | Adabas userview
J | IMS segment layout | V | VSAM file (physical)
K | IMS userview | W | Physical VSAM view

A field short name must conform to the rules for coding Adabas field names. See the section ADACMP (COMPRESS-DECOMPRESS) in the Adabas Utilities documentation and Field Names in section Adabas Design of the Adabas Concepts and Facilities documentation.

Field short names for userviews of Adabas, IMS and VSAM files need not be unique.

For fields within a redefinition, parameter Field short name must be blank.

Field short names for SQL tables and views are maintained internally by Predict and cannot be modified by users.

Rotated fields of files of type A (with SQL usage), type AT and B have the same short name and are identified uniquely by an occurrence number (column Occ).

## Suppression / Null Value Option

- For fields of Adabas files, the suppression option is indicated in column S of the Add/Copy/Modify screen.

- For fields of SQL files, the null value option is indicated in column N of the Add/Copy/Modify screen.

For groups and for fields within a redefinition, this attribute must be blank. For other fields, one of the following values can be specified:

F | Fixed length
N | Null value suppression
R | Not null
U | Null counted
blank | Normal suppression

Parameter | SQL File Types * | Other File Types
--- | --- | ---
Null value suppression |  | N
Fixed Length |  | F
Null allowed | U | U
Not null | R | R
Normal suppression |  | blank

* See Add/Copy/Modify Screen for SQL Fields for a list of SQL file types.

See also section ADACMP (COMPRESS-DECOMPRESS) in the Adabas Utilities documentation.

### Profile Parameter Automatic Null Value

With the profile parameter Automatic null value you can determine an automatic Suppression/Null Value option when fields are added in Predict. See Customizing Predict with Profiles in the section Predict User Interface in the Introduction to Predict documentation.

The value depends on the file type. See table below.

Parameter | All SQL File Types except X | File Type X | Other File Types
--- | --- | --- | ---
Unique option = Unique, or Descriptor type = Primary, or Field format = serial | R | R | N
Others | U | blank | N

Note
SQL file types include files of type A with parameter Adabas SQL usage set to Y. See list in the section Add/Copy/Modify Screen for SQL Fields.

For DB2 fields with Unique option = unique, values R and U are possible.

## Variable Length Option - IMS

The variable length option for IMS fields is indicated in column S of the Add/Copy/Modify screen. The following values are valid:

Y | Variable length
blank | Fixed length

## Null Default Option

The NULL default option for fields of SQL tables/views is indicated in the column Df of the Add/Copy/Modify screen. Possible values:

N | No default
Y | With default
blank | none

For Ingres fields with format OK or TK, the following additional values are possible:

S | SYSTEM_MAINTAINED
T | not SYSTEM_MAINTAINED
U | with default SYSTEM_MAINTAINED
V | with default not SYSTEM_MAINTAINED
W | not default not SYSTEM_MAINTAINED

This parameter must be blank for fields within a redefinition.

## Natural Field Length

The Natural field length is indicated in column NAT-l of the Add/Copy/Modify screen. The following rules apply:

- The parameter has to be specified if the field can be:

  - alphanumeric and greater than 253

  - graphic and greater than 126

  - numeric p.q (m/n) where p+q > 29 or q > 7.

    See table of valid formats and lengths in the section Field Length.

- The value specified here is the length that Natural can use for the field as defined in the DDM.

## Do Not Convert Option

The "do not convert" option is allowed for A and AV format fields of the following file types:

- Adabas file/userview

- Conceptual file

## Related Standard File

This parameter is described in the section Rippling.

## Check against standard

This parameter is described in the section Rippling.

## Natural Attributes

### Headers

The Natural headers 1 - 3 are included in DDMs generated from the file containing the field.

Alphabetic characters in Natural headers are converted to upper-case if the Predict parameter Upper/lower case has been set to Y. See the section Defaults in the Predict Administration documentation.

### Index on PE Group Level

If you enter Y in this field and execute the Natural Area Editor command .V for a DDM containing the field object, the maximum occurrences of periodic groups is generated on group level.

If this parameter is left blank (default), the maximum occurrences is generated for each element in the group.

### Edit mask

The Natural edit mask. See the description of the DISPLAY statement in the Natural Statements documentation for further details.

Alphabetic characters in the Natural edit mask are converted to upper-case if the Predict parameter Upper/lower case has been set to Y. See the section Defaults in the Predict Administration documentation.

### Dynamic length

If you enter Y, fields with format LO or AV in files of type A/U are generated with dynamic length in the DDM.

## Hidden

Specifies that the column is not visible in the result for SQL statements unless you explicitly refer to the column by name.

If you enter Y, columns are not visible.

## Additional attributes / Associations

The following additional options in the Additional attributes / Associations line are available for fields. Standard options are described in the section Additional attributes / Associations.

### Verification

Enter Y in Associations field to call the Predict Link Editor to edit the verification list of the field. Up to 50 verifications can be linked to a field via "Is verified by VE".

This editor can also be invoked by:

- Selecting L (link children with association VE) in the Field Maintenance Menu.

- Entering command `LINK ELEMENT VERIFICATION field-id file-id`.

See the section Editors in Predict in the Predict Reference documentation.

### Additional attributes

Enter Y in this field to define additional attributes. The attributes that can be defined depend on the field type. See Defining Additional Attributes of Fields.

### On this page

- Add/Copy/Modify Screen
- Field Type
- Level Number
- Field Format
- Character Set
- Character Set - Adabas
- Field Length
- Descriptor Type
- Descriptor Type - continued
- Maximum Number of Values / Occurrences
- Unique Option
- Field Short Name
- Suppression / Null Value Option
- Variable Length Option - IMS
- Null Default Option
- Natural Field Length
- Do Not Convert Option
- Related Standard File
- Check against standard
- Natural Attributes
- Hidden
- Additional attributes / Associations