HP 3000 Manuals

Using Verify to Check MERGE/XL Options [ SORT-MERGE/XL General Users Guide ] MPE/iX 5.0 Documentation


SORT-MERGE/XL General Users Guide

Using Verify to Check MERGE/XL Options 

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
          (c) 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.



MPE/iX 5.0 Documentation