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 > Chapter 3 Using SORT/XL Interactively

Determining the File Format

» 

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

 » Glossary

 » Index

When creating a file for sorting data, first determine the information to include and its format. For example, the input file EMPLOYEE contains four key data items in each record (employee's last name, first name, job title, and employee number). The format for the first two lines of the file EMPLOYEE is shown in Figure 3-1 “File Format For Sorting”

Figure 3-1 File Format For Sorting

File Format For Sorting

The file format shown in Figure 3-1 allots 11 characters (columns) for last names beginning in position 1; 11 characters for first names, beginning in position 12; 19 characters for jobs titles, beginning in position 23; and 4 characters for employee numbers, beginning in position 42. Use the starting position location for each key data item as tab settings when creating the file. A single line record can contain up to 80 characters.

For clarity in reading the report when it is printed, allow enough characters for the longest piece of information in each key data item, and some blank spaces between them.

When creating multiple files containing similar information to be sorted and then merged, ensure the key data item starting positions and data length are identical in all files.

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