HP 3000 Manuals

SORT-MERGE/XL General Users Guide

Merging Files Using Multiple Keys 

You can combine files based on more than one key.  The files must contain
the same data format, and the key data items must start at the same
character position (column) and be the same length.

To combine EMPLOYEE and NEWHIRES into a new file named COMPANY by last
name, first name, and job title, enter the following sequence of
commands:

          :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   
          >END   

This would arrange the two CARLSON entries in their proper alphabetical
order with regard to their first names.  Only the two CARLSON entries are
shown in the following example:

          :EDITOR   

          HP32201A.07.17 EDIT/3000 WED, JUN  3, 1987, 12:30 PM
          (c) HEWLETT-PACKARD CO. 1985
          /TEXT NEWHIRES   
          FILE UNNUMBERED
          /LIST 5/6   
                          1         2         3         4
                 1234567890123456789012345678901234567890123456789

          5      CARLSON    PETER      BUYER              8043
          6      CARLSON    ROBERTA    TREASURER          3586

MPE/iX 5.0 Documentation