SORT-MERGE/XL General User's Guide (32650-90883)

58 Chapter4
Using MERGE/XL Interactively
Getting a Printout of MERGE/XL Results
>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.
Getting a Printout of MERGE/XL Results
To receive a hard copy (printed report) of the results of the merge operation shown in the
examples above, request a copy by entering LIST ALL, OFFLINE from within the EDIT/V
subsystem. To receive a printed copy, enter the following commands:
:EDITOR
HP32201A.07.17 EDIT/3000 WED, JUN 3, 1987, 12:45 PM
© HEWLETT-PACKARD CO. 1985
/TEXT COMPANY
FILE UNNUMBERED
/LIST ALL, OFFLINE
A message appears on your terminal screen indicating the printing has begun:
***OFF LINE LISTING BEGUN***
Wait a few minutes to allow the job to be processed; then get your printout from the system
printer.