HP 3000 Manuals

SORT-MERGE/XL General Users Guide

Sorting the File 

Before the newly created file NEWHIRES can be merged with any other files
it must first be sorted.  Sort the file NEWHIRES using the same >KEY
command used in the file EMPLOYEE (>KEY 1, 11; 12, 11; 23, 19):

          :SORT  

          HP32214A.01.00  SORT/3000 WED, JUN  3, 1987, 11:35 AM
          (c) HEWLETT-PACKARD CO. 1986

          >INPUT NEWHIRES    
          >OUTPUT NEWHIRES    
          >KEY 1, 11; 12, 11; 23, 19    
          >END    
          PURGE OLD OUTPUT FILE NEWHIRES.GROUP.ACCOUNT ? Y 

             <<The SORT Statistics Appear Here>>
          :EDITOR    

          HP32201A.07.17 EDIT/3000 WED, JUN  3, 1987, 11:40 AM
          (c) HEWLETT-PACKARD CO. 1985
          /TEXT NEWHIRES    
          FILE UNNUMBERED

          /LIST ALL    
                            1         2         3         4
                   123456789012345678901234567890123456789012345

          1        ADAMS      JERROLD    INSPECTOR          8044
          2        CARLSON    PETER      BUYER              8043
          3        CLARK      STEVE      ASSEMBLER          8046
          4        MATHEWS    EDDY       PLANNER            8045

This chapter contains examples of merging this file with the file
EMPLOYEE in ways useful to a Personnel Department.

In the above example, after you entered the >END command, the system
displayed the message:

          PURGE OLD OUTPUT FILE NEWHIRES.GROUP.ACCOUNT ? Y 

This message tells you that a file named NEWHIRES already exists in your
group and account, and asks if you want the old version purged.  If you
reply YES, the old version of NEWHIRES is purged and a new version
containing the information from this sort is created.  If you reply NO,
you are prompted for a new file name.  You then enter a new, unique file
name; and you have two files, the original file named NEWHIRES and the
newly created file.

MPE/iX 5.0 Documentation