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

Sorting the File

MPE documents

Complete PDF
Table of Contents
Index
Glossary

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.




Creating an Editor File


Initiating an Interactive MERGE/XL Session