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 |
The name of the VIRTUAL data set that you declared in the GenFormat parameter file -or- 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
)
 |