Sorting the records of the data set

Steps:

1. Type SORT KEYS in the COMMAND field.
2. Press Enter. File-AID redisplays the data set in ascending key (first five characters of each record) order. The number of records sorted is indicated in the message in the top right corner of the display as illustrated in the following figure.

Edit - After SORT KEYS

More about the SORT command:

• You can sort records on one or more fields by using the syntax:

or

where "from" and "to" are column locations of the field(s) to be used as sort fields and /field-name is the name of field in a supplied record layout. A/D indicates ascending (A) or descending (D) sequence; if you do not specify either A or D, File-AID assumes an A (ascending) sequence order.

• If a keyed file is sorted on a field other than the key field, you are not able to save your changes until all records are in key sequence. In this case, use the SORT KEY command to return the records to key sequence before saving your changes.
• The default parameter for SORT is KEYS for a keyed file. Thus the commands SORT and SORT KEYS are the same.
• For RRDS and BDAM files the SORT command sorts records in relative record number (RRN or RBN) order.

• EBCDIC and Unicode UTF-8 or UTF-16 SORT Order:

  The collating sequence of Unicode is different than that of EBCDIC. The SORT command allows you to reorder the data. The SORT command always operates on the underlying data; thus, when the data is Unicode, the results may be different than for EBCDIC data.

Deleting duplicate records - D (Delete) line command

Use the D (Delete) and DD (Delete Block) line commands to delete records.

DD (Delete block) - Delete Duplicate Records

Steps:

1. Type DD (delete block) in the sequence number field of line numbers 3 and 7.
2. Press Enter. File-AID deletes the lines of data between the delete block commands as illustrated in the following figure.

After Duplicates Have Been Deleted