Use the >VERIFY command to check the options specified for the merge operation. Enter the >VERIFY command after the >KEY command, as follows:
:MERGE
HP32214A.01.00 MERGE/3000 WED, JUN 3, 1987, 12:15 PM
© HEWLETT-PACKARD CO. 1986
>INPUT EMPLOYEE, NEWHIRES
>OUTPUT COMPANY
>KEY 1, 11; 12, 11; 23, 19
>VERIFY
|
MERGE/XL responds to the >VERIFY command with the following display:
INPUT FILES = EMPLOYEE, NEWHIRES
OUTPUT ENTITY = COMPANY
KEY POSITION LENGTH TYPE ASC/DESC
1 11 BYTE ASC (MAJOR KEY)
12 11 BYTE ASC
23 19 BYTE ASC
|
This display tells you that the input files are EMPLOYEE and NEWHIRES, the output file is COMPANY, and the merge is based on three designated keys. The first key (identified as the major key) starts in position (column) 1 and is 11 characters (columns) long. In the case of ties on the first key, entries in the input files are merged by the second key. The second key starts in character position 12 and is 11 characters long. The third key starts in character position 23 and is 19 characters long. The display also shows that the default values for TYPE (BYTE) and the order under ASC/DESC (ASC for ascending) are used. Refer to the >VERIFY command in Chapter 6 for additional information.
