Mainframe

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…

4 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…

4 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…

4 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…

4 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…

4 years ago

SQL wildcards use in Queries

SQL wildcards are used to substitute one or more characters in a string. We use SQL wildcards when we need…

4 years ago

HAVING Clause in DB2 SQL Queries

HAVING clause is used to apply a filter on the result of  GROUP BY based on the specified condition. The conditions…

4 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…

4 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…

4 years ago

DB2 TRIM – Remove any characters from STRING

The DB2 TRIM function removes bytes from the beginning, from the end, or from both the beginning and end of…

4 years ago