Ahlsort draft 1
| Developer(s) | Ahlbrandt Software, Inc. |
|---|---|
| Stable release | 14.7
/ June 1, 2022 |
| Engine | |
| Operating system | Windows, Linux, AIX, Solaris, IBM z/Linux |
| Platform | Cross-platform |
| Type | Data Management |
| License | Proprietary |
| Website | www.ahlsort.com |
Search Ahlsort draft 1 on Amazon.
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.[1]
The command syntax of AHLSORT is compatible with IBM's DFSORT for z/OS.[2]
The developers of AHLSORT strive 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.
General Features
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.
[3]
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.
[4]
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.[5]
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.[6]
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.
Other Features
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 can 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'
References
- ↑ "Syncsort Inc. v. Sequential Software, Inc., 50 F. Supp. 2d 318 (D.N.J. 1999)". January 28, 1999.
- ↑ "IFL – A Cost Efficient zSeries Platform?". September 3, 2014.
- ↑ "SORT control statement". March 3, 2021.
- ↑ "MERGE control statement". March 3, 2021.
- ↑ "INREC statement notes". March 3, 2021.
- ↑ "Join statement in JCL". June 25, 2020.
This article "Ahlsort draft 1" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:Ahlsort draft 1. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.
