User:RainMoose/sandbox

AHLSORT AHLSORT is a General Purpose Sort/Merge Utility for processing Flat Files

AHLSORT is one of many commercially available general purpose sort utilities on the market.

The command syntax of AHLSORT is compatible with IBM's DFSORT for z/OS.

The developers of AHLSORT strives for 100% compatibility with IBM's DFSORT for z/OS providing the ability to process data on non-z/OS platforms such as Microsoft Windows, Linux, Oracle Solaris, AIX and z/Linux.

Sort
Sorting is the process of rearranging the records in a file in a new order. Such as sorting by Name, Address, Telephone Number or ZIP Code. The SORT control statement is used to invoke the sorting process.

Merge
Merging is the process of combining sequences of sorted records in two or more input files into a single sorted output file. The MERGE control statement is used to invoke the merging process.

Reformat
Reformatting is the process of changing input records to add or remove data fields. Reformatting may be performed with or without sorting or merging. Reformatting is performed with the INREC and OUTREC control statements.

Join
Joining is the process of Joining two different record types from two files into a single output file Joining files is performed by using the JOINKEYS and JOIN control statements.

Aggregate
Aggregating is the process of consolidating similar records by summing, averaging, computing minimums or maximums of data in the records. Aggregating is performed by using the SORT control statement.

ICETOOL
ICETOOL is a program offered by IBM to allow multiple DFSORT processing steps to be combined into a single script. AHLSORT supports many of the options used ICETOOL in the COPY, COUNT, DATASORT, DEFAULTS, DISPLAY, MERGE, MODE, OCCUR, RANGE, RESIZE, SELECT, SORT, SPLICE, STATS, SUBSET, UNIQUE and VERIFY commands.

SYMNAMES
AHLSORT supports the DFSORT SYMNAMES functionality by allowing symbolic names to be specified for positions in input and output records.

JCL DD DCB Information
IBM Mainframes store dataset (file) attribute information such as record length, record format, block size in the disk VTOC. In Windows, Unix and Linux filesystems, the concept of a VTOC does not exist. The information that is stored in the VTOC and be specified in the input (and output) file specification by coding the DCB= parameter. For example: to process a file from the mainframe that contains Fixed Length records of 80 bytes each, the command would be: > ./ahlsort ' SORT FIELDS=(72,8,ZD,A)' 'INPUT,DCB=(LRECL=80,RECFM=F)' 'OUTPUT'