Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
More options
HP.com home

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

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

 » Glossary

 » Index

spacerspacerspacer
spacer
spacer
   
 

HP Part Number: 32650-90883

Edition: 

Published: E0300

Table of Contents

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
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
DATA
SYNTAX
DISCUSSION
EXAMPLES
ADDITIONAL DISCUSSION
END
SYNTAX
DISCUSSION
EXAMPLES
ADDITIONAL DISCUSSION
EXIT
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
KEY
SYNTAX
PARAMETERS
DISCUSSION
EXAMPLES
ADDITIONAL DISCUSSION
LANGUAGE
SYNTAX
PARAMETERS
DISCUSSION
EXAMPLES
ADDITIONAL DISCUSSION
OUTPUT (MERGE/XL)
SYNTAX
PARAMETERS
DISCUSSION
EXAMPLES
ADDITIONAL DISCUSSION
OUTPUT (SORT/XL)
SYNTAX
PARAMETERS
DISCUSSION
EXAMPLE
ADDITIONAL DISCUSSION
RESET
SYNTAX
DISCUSSION
EXAMPLE
SHOW
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
VERIFY
SYNTAX
DISCUSSION
EXAMPLE
ADDITIONAL DISCUSSION
:(MPE Command)
SYNTAX
DISCUSSION
EXAMPLE
ADDITIONAL DISCUSSION
:EOD
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
Glossary
Index

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
   


Preface  
Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© Hewlett-Packard Development Company, L.P.