DDS Type of Name or Specification (Position 17)

Type a value in this position to identify the type of name or, for logical files, the type of specification. If you specify a name type, the name is specified in positions 19 through 28.

The valid entries for physical files are:

Entry
Meaning

R
Record format name

Blank
Field name

K
Key field name
Note:
Specify only one R because a physical file can contain only one record format.

The valid entries for logical files are:

Entry
Meaning

R
Record format name

J
Join specification

Blank
Field name or select/omit AND condition

K
Key field name

S
Select field name

O
Omit field name

For more information on types of names, see DDS Name (Positions 19 through 28). For more information on join specifications, see JOIN (Join) Keyword--Join Logical Files Only for Physical and Logical Files.