SORT-MERGE/XL General Users Guide: HP 3000 MPE/iX Computer Systems

»

Technical documentation


	Complete book in PDF


»	Feedback

» Table of Contents

» Glossary

» Index

HP Part Number: 32650-90499

Edition: Third Edition

Published: Printed in U.S.A.1994

Table of Contents

1 Introduction To SORT-MERGE/XL

What Can You Sort?
How Can You Sort?
The SORT/XL Process
The MERGE/XL Process

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

SYNTAX
PARAMETERS
DISCUSSION
Using modspec With EACH
Using modspec With MERGE
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
ADDITIONAL DISCUSSION

SYNTAX
DISCUSSION
EXAMPLES
ADDITIONAL DISCUSSION

SYNTAX
DISCUSSION
EXAMPLES
ADDITIONAL DISCUSSION

SYNTAX
DISCUSSION
EXAMPLE
ADDITIONAL DISCUSSION

INPUT (MERGE/XL)

SYNTAX
PARAMETERS
DISCUSSION
EXAMPLE
ADDITIONAL DISCUSSION

INPUT (SORT/XL)

SYNTAX
PARAMETERS
Compatibility Mode Scratch File Size
Compatibility Mode Scratch Filename
Native Mode Scratch File Size
Native Mode Scratch Filenames
DISCUSSION
EXAMPLE
ADDITIONAL DISCUSSION

SYNTAX
PARAMETERS
DISCUSSION
EXAMPLES
ADDITIONAL DISCUSSION

SYNTAX
PARAMETERS
DISCUSSION
EXAMPLES
ADDITIONAL DISCUSSION

OUTPUT (MERGE/XL)

SYNTAX
PARAMETERS
DISCUSSION
EXAMPLES
ADDITIONAL DISCUSSION

OUTPUT (SORT/XL)

SYNTAX
PARAMETERS
DISCUSSION
EXAMPLE
ADDITIONAL DISCUSSION

SYNTAX
DISCUSSION
EXAMPLE

SYNTAX
PARAMETERS
EXAMPLES
Displaying the ASCII Collating Sequence
Displaying the EBCDIC Collating Sequence
Displaying Recurring Collating Sequences
Using the >SHOW Command TABLE Parameter
ADDITIONAL DISCUSSION

SYNTAX
DISCUSSION
EXAMPLE
ADDITIONAL DISCUSSION

:(MPE Command)

SYNTAX
DISCUSSION
EXAMPLE
ADDITIONAL DISCUSSION

SYNTAX
EXAMPLE
ADDITIONAL DISCUSSION

A Error Messages

SORT/XL Error Messages
MERGE/XL Error Messages
Recovery Procedures

B ASCII/EBCDIC Character Sets

C Native Language Collating

List of Figures

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

List of Tables

2-1 SORT-MERGE/XL Commands
B-1 ASCII/EBCDIC Character Sets


Feedback to webmaster