How to Delete Duplicate Rows from DB2 Table There can be more than one way to deal with this situation, but here this mainframe tutorial will give you a very simple method of solving this problem. ; ; ; ; Step 1: Unload the Table to a flat file using DB2 utility. Step 2: SORT […]
How to Delete Duplicate Rows from DB2 Table Read More »
Low values to Spaces using SORT There may be situation where you wish to replace the low values hex (’00’) in a file to spaces hex (’40’). The following JCL can come handy for Method 1: If position of low value char is not known and all such chars are to be //SORTIN DD DSN=FILE.WITH.LOW.VALUES,
Low values to Spaces using SORT Read More »
How to Find the Record length of DB2 Table Recently I was working on an assignment which required me to prepare a list of all the DB2 Tables and their corresponding lengths. The list of all the DB2 tables can easily be found from the SYSIBM.SYSTABLES, by extracting the list of “NAMES”  from this table by
Record length of DB2 Table Read More »
Check if Day light saving is in Effect Day light saving begins in US on second sunday in march and ends on first sunday in november at 2AM local time. To check if daylight saving is in effect you can run the following query on mainframe. Â Â Â Â Â Â Â Â SELECT CURRENT TIMEZONE
Check if Day light saving is in Effect Read More »
What is the difference between Cursor stability and Repeatable read. 1)Â Â Â Â Â DB2 takes a lock on the page cursor is accessing and releases it as the cursor moves on. 2)Â Â Â Â Â This isolation level is not the default. 3)Â Â Â Â Â This provides more concurrency and lesser integrity. 4)Â Â Â Â Â The lock is acquired at page level in both
What is the difference between Cursor stability and Repeatable read. Read More »
Wildcard character % in DB2 If you wish to fetch a row from a DB2 table and you do not know what is the exact value in a column then you can use wild card character % (percent wild card character) Wild card character % can be used as a substitue for n number of
Wildcard character percent in DB2 Read More »
SORT JCL to copy when location of matching data is not known If you wish to copy all the records which have a particular string in the file, but its location may vary or is not known then you can use the following sort card  INCLUDE COND=(1,100,SS,EQ,C’ABC’) The above sort card will look for string
SORT JCL to copy when location of matching data is not known Read More »
S0C4 Abend What is a S0C4 Abend? S0C4 Abend is a protection exception when a virtual address cannot be mapped with a physical address. When S0C4 Abend occurs An Invalid address referenced due to subscript error In a group Move the length of the receiving field was defined incorrectly Moving variable length record which is
Smallest Program in COBOL PROGRAM IDENTIFICATION DIVISION.                                        PROGRAM-ID. PGM000.                                             PROCEDURE DIVISION.                                                DISPLAY ‘SMALLEST PROGRAM BY MAINFRAMEWIZARD ‘                 STOP RUN.                                                   OUTPUT SMALLEST PROGRAM BY MAINFRAMEWIZARD                                                                              Â
Problems in Editing a huge file We recently faced an abend in our production cycle and it was due to a bad record in the file. We had to edit few records in the file after taking the backup but the file was really huge. When we tried to open the file in edit mode,
Problems in Editing a huge file Read More »
