SORT-MERGE/XL General User's Guide: 900 Series HP 3000 Computer Systems

Preface

1 Introduction To SORT-MERGE/XL

What Can You Sort?

How Can You Sort?

The SORT/XL Process

The MERGE/XL Process

Large File Support

2 Getting Started With SORT-MERGE/XL

SORT- MERGE/XL Commands

Key Data Items

Sorting Files By A Single Key Data Item

Sorting Files By Multiple Key Data Items

Merging Files By Key Data Items

Collating Sequences

ASCII/EBCDIC

Native Language Collating Sequences

User-Defined Sequences

Ascending/ Descending Order

Translation Tables

SORT-MERGE/XL Files

Display File

Input File

Output File

List File

Scratch File

Text File

Prompt File

3 Using SORT/XL Interactively

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

4 Using MERGE/XL Interactively

Determining File Format

Creating an Editor File

Sorting the File

Initiating an Interactive MERGE/XL Session

Exiting MERGE/XL

Merging Files Using a Single Key

Merging Files Using Multiple Keys

MERGE/XL Statistics Report

Using Verify to Check MERGE/XL Options

Getting a Printout of MERGE/XL Results

Using the MPE XL :PRINT Command

5 Using SORT-MERGE/XL in Batch Mode

Building a Job File

Initiating a Batch Job

Checking on the Status of your Job

Scheduling a Batch Job

Terminating a Batch Job

6 SORT-MERGE/XL Commands

ALTSEQ

EXAMPLES

Standard ASCII Collating Sequence

Using the EACH Parameter

Using >ALTSEQ Without the EACH Parameter

Numeric Byte Specification

Using a Range String Specification

Collating Upper Case Before Lower Case

Collating Lower Case Before Upper Case

Merging Unequal Strings

DATA

END

EXIT

INPUT (MERGE/XL)

INPUT (SORT/XL)

KEY

LANGUAGE

OUTPUT (MERGE/XL)

OUTPUT (SORT/XL)

RESET

SHOW

EXAMPLES

Displaying the ASCII Collating Sequence

Displaying the EBCDIC Collating Sequence

Displaying Recurring Collating Sequences

Using the >SHOW Command TABLE Parameter

VERIFY

:(MPE Command)

:EOD

A Error Messages

SORT/XL Error Messages

MERGE/XL Error Messages

Recovery Procedures

B ASCII/EBCDIC Character Sets

C Native Language Collating

Glossary

Index

2-1 Key Data Item Positions

2-2 Alphabetical Sort By Last Name

2-3 Numerical Sort By Social Security Number

2-4 Sorted File SORTED1

2-5 Sorted File SORTED2

2-6 Merged File MERGED1

3-1 File Format For Sorting

4-1 File Format For Merging

C-1 MPE XL - Supported Native Languages

2-1 SORT-MERGE/XL Commands

B-1 ASCII/EBCDIC Character Sets