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

Chapter 3 Using SORT/XL Interactively

MPE documents

Complete PDF
Table of Contents
Index
Glossary

Table of Contents
Determining the File Format
Creating an Editor File
Initiating a SORT/XL Interactive Session
Exiting SORT/XL
Single Key Alphabetical Sorting
SORT/XL Statistics Report
Multiple Key Alphabetical Sorting
Using >VERIFY to Check Options
Sorting Numerically
Sorting and Merging Multiple Files
Saving Selected Key Data Only
Using the MPE XL :PRINT Command
Using >SHOW to Display the Collating Sequence
Using >SHOW to Display the Translation Table
Defining Your Own Collating Sequence
Using the Terminal as the Output File
Using the Terminal as the Input File and the Output File
Using File Equations in SORT/XL
This chapter introduces using SORT/XL in an interactive session. The examples use a variety of SORT/XL commands and options to provide an overview of how SORT/XL operates. Refer to Chapter 6 for information on all SORT-MERGE/XL commands, including their syntax, parameters, options, and examples of their operation.

Throughout this chapter two files (EMPLOYEE and COMPANY) are used to illustrate how SORT/XL operates. They are patterned on typical information that might be used by the Personnel Department of your company. The data is listed by the employee's last name, first name, job title, and employee number. The file EMPLOYEE contains unsorted data on existing employees and is designated as the >INPUT file in all examples. The file COMPANY contains the sorted data in various orders and is designated as the >OUTPUT file in all examples. A third file (NEWHIRES) contains unsorted data on new employees and is designated as the >INPUT file in the example showing how to sort and merge multiple files in a single operation.




SORT-MERGE/XL Files


Determining the File Format