Mainframe

CSV – PIPE TO FIXED LENGTH FORMAT

Let's say your input file has data that is delimited by PIPE or COMMA e.g. you have uploaded a CSV…

4 years ago

CHANGE Input Data using SORT Lookup

CHANGE in OUTREC statement can be used to look up and change the content in the file while sorting. Build…

4 years ago

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

4 years ago

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…

4 years ago

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…

5 years ago

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…

5 years ago

Conditional Expressions use in COBOL

Conditional expressions identify conditions that are tested to enable the object program to select between alternate paths of control depending…

5 years ago

EVALUATE statement in COBOL Programs

EVALUATE statement is used for conditional processing which helps in eliminating a series of nested IF statements to test several…

5 years ago

DB2 EXPLAIN: Access Path for Query Optimization

You can use the DB2 EXPLAIN statement to determine the access paths for the SELECT parts of your statements. DB2…

5 years ago

MERGE control statement use in SORT

The MERGE control statement must be used when a merge operation is to be performed; this statement describes the control…

5 years ago