PDSE

Header and Trailer – SORT Detail records between these

Understanding Header and Trailer Processing: In mainframe data processing, it’s essential to handle files that contain Header and Trailer records correctly. Standard sort utilities sort all records — including headers and trailers — unless explicitly handled. To avoid rearranging records post-sort, ICETOOL offers options that allow detail records to be sorted while preserving headers and

Header and Trailer – SORT Detail records between these Read More »

FILEAID

FILEAID in Batch Mode with Examples

FILEAID is an interactive software product that increases data processing productivity in both program development and daily file and records maintenance. It is a data manipulation program that consolidates the functions of many standard IBM utilities. FILE-AID combines the data and file processing of the following nine IBM utilities into one tool.These utilities are IDCAMS, IEBGENER,

FILEAID in Batch Mode with Examples Read More »

SORT DATE Functions

SORT DATE Functions with Examples

When working with mainframe batch processing, developers frequently need to extract, copy, or format records based on the current date, past dates, or future dates. Instead of hardcoding a constant date like 2021-01-01 into your JCL every day, DFSORT provides dynamic Date Functions that evaluate the system date at runtime. These date functions allow you to write

SORT DATE Functions with Examples Read More »

IEFBR14 JCL Utility

Convert Date DDMMMYY to MM/DD/YY Format

DFSORT doesn’t have a built-in function for Convert Date – interpreting the month field of date in DDMMMYY formats as numeric values but you can use INREC and OUTREC statements to translate the month back and forth. Let’s take an example assuming that the DDMMMYY date is in positions 1-7. BUILD=(3,3, 3,3, CHANGE=(2,C’Jan’,C’01’,C’Feb’,C’02’,C’Mar’,C’03’,C’Apr’, C’04’,C’May’,C’05’,C’Jun’,C’06’,C’Jul’,C’07’,C’Aug’,C’08’, C’Sep’,C’09’,C’Oct’,C’10’,C’Nov’,C’11’,C’Dec’,C’12’),

Convert Date DDMMMYY to MM/DD/YY Format Read More »

OUTREC

OUTREC control statement use in SORT

OUTREC control statement is used to reformat (adds, deletes, or reformats fields) each record after they are sorted, merged, or copied by specifying all of its items one by one. This statement supports a wide variety of parsing, editing, and reformatting tasks. We can even add spaces/zeroes/any character into the output record based on the requirement.    

OUTREC control statement use in SORT Read More »

XML statement generation using SORT

We will generate XML statement from input records having fixed positions using SORT. We will use REMOVECC, HEADER1, BUILD, JFY, SHIFT, LEFT, LEAD, TRAIL, LENGTH, SQZ & TRAILER1 parameters. REMOVECC: The REMOVECC parameter generates reports that do not include ANSI carriage control characters that specify printer actions (for example, skipping a line or ejecting a

XML statement generation using SORT Read More »

Uppercase

SAVE discarded records using SORT

Record Selection for Output File can be done using STARTREC, ENDREC, INCLUDE/OMIT, SAVE Parameters. Use SAVE to include records for OUTFIL processing that have not been included in any other OUTFIL group. If SAVE is specified on more than one OUTFIL group, then each of these OUTFIL groups gets the records that were discarded from

SAVE discarded records using SORT Read More »

PDSE

JOINKEYS File Match and Comparison

The JOINKEYS File Match utility help in comparing two files. JOINKEYS File Match operation is controlled by JOINKEYS, JOIN, and REFORMAT control statements. The SORTJNF1 and SORTJNF2, are the DD statements used to specify the files which will be used to perform the join operations. During JOIN operation on two files, each record from the

JOINKEYS File Match and Comparison Read More »

Uppercase

OUTFIL control statement in SORT JCL

The OUTFIL control statement describes the output file(s) and the processing to be done on the output records. OUTFIL processing is supported for sort, merge, and copy applications. Use the OUTFIL control statement to create multiple output files without making multiple passes through the input data. OUTFIL control statement Examples Example 1 The following example

OUTFIL control statement in SORT JCL Read More »

Scroll to Top