HPlogo SORT-MERGE/XL General Users Guide: HP 3000 MPE/iX Computer Systems > Chapter 4 Using MERGE/XL Interactively

Sorting the File

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

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 

     © 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 

     © 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.

Feedback to webmaster