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

Saving Selected Key Data Only

MPE documents

Complete PDF
Table of Contents
Index
Glossary

It is possible to create an output file containing only those key data items you need rather than the entire file. To do this you use the KEY parameter of the >OUTPUT command.

For example, if you want a listing of all employees, showing their last names only, enter the following sequence of commands:

  :SORT

  HP32214A.01.00  SORT/3000 WED, JUN  3, 1987,  9:13 AM
  (C) HEWLETT-PACKARD CO. 1986

  >INPUT EMPLOYEE
  >OUTPUT COMPANY, KEY
  >KEY 1, 11
  >END

     <<The SORT Statistics Appear Here>>

  END OF PROGRAM
  :EDITOR

  HP32201A.07.17 EDIT/3000 WED, JUN  3, 1987,  9:14 AM
  (C) HEWLETT-PACKARD CO. 1985
  /TEXT COMPANY
  FILE UNNUMBERED
  /LIST ALL

          12345678901

    1     ANDERSON
    2     ANDERSON
    3     ANDERSON
    4     CARLSON
    5     FISHER
    6     JOHNSON
    7     LANGE
    8     SMITH
    9     TAYLOR
   10     ZIMMER

To receive a hard copy (printed report) of the results of the sort operation shown in the examples above, request a copy by entering LIST ALL, OFFLINE from within the EDIT/V subsystem. To receive a printed copy follow the procedure below:

  :EDITOR

  HP32201A.07.17 EDIT/3000 WED, JUN  3, 1987,  9:15 AM
  (C) HEWLETT-PACKARD CO. 1985
  /TEXT COMPANY
  FILE UNNUMBERED
  /LIST ALL, OFFLINE

A message appears on your terminal screen indicating the printing has begun:

  ***OFF LINE LISTING BEGUN***

Wait a few minutes to allow the job to be processed; then get your printout from the system printer.




Sorting and Merging Multiple Files


Using the MPE XL :PRINT Command