Primary Key Syntax

Syntax: PRIMARY KEY OF dataset IS (keyitems)

Where

Is

PRIMARY

An optional word

KEY

A required word

OF

An optional word

dataset

Any of the following:

  • The name of the VIRTUAL data set that you declared in the GenFormat parameter file
  • A data set in the DMSII database

IS

An optional word

keyitems

One or more data items that will make a unique key. Separate each data item with a comma. The parentheses are required.

Example:

The following example uses all of the key words and only one data item:

Primary Key of CUSTOMER is (CUST-ID)

The following example does not use the optional key words; it does, however, use a combination of data items to create a primary key.

KEY ORDER-DETAIL

(

ORD-NBR,

LINE-NBR

)