JCL

Job Control Language is a name for scripting languages used on IBM mainframe operating systems to instruct the system on how to run a batch job or start a subsystem.

Header and Trailer – SORT Detail records between these

The file having Header and Trailer needs to be sorted but standard sort parameters will sort all records including header…

3 years ago

SPLICE – Join records with missing fields

SPLICE normally requires reformatting the records of two or more data sets so they can be JOINED. In other words,…

3 years ago

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…

3 years ago

Replace Low Values with Spaces using SORT

Many times LOW VALUES are present in the input file and the job abends. For a quick fix, developers have…

3 years ago

SORT DATE Functions with Examples

Using SORT DATE Functions you can dynamically insert the date, like ‘yyyy-mm-dd' or any format instead of a constant date…

3 years ago

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…

3 years ago

VSAM file status code & VSAM file initialization

VSAM file status code indicates the status of the operation. VSAM files require at least one data record to be…

3 years ago

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…

3 years ago

ICETOOL Utilities and Operations with Examples

ICETOOL Utilities uses DFSORT to perform multiple operations on one or more data sets in a single job step. ICETOOL…

3 years ago

VSAM EXPORT-IMPORT using IDCAMS with Examples

The VSAM EXPORT-IMPORT commands are usually used to take the backup and recovery. The EXPORT option is used to export…

4 years ago