HPlogo SORT-MERGE/XL General User's Guide > Chapter 4 Using MERGE/XL Interactively

Using Verify to Check MERGE/XL Options

MPE documents

Complete PDF
Table of Contents
Index
Glossary

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.



MERGE/XL Statistics Report

Getting a Printout of MERGE/XL Results