Posts

Showing posts from February, 2021

What is Job control Language?

Image
In today's world where the pandemic has changed the dynamics of digital world and unearth the gap in the mainframe skills, which  runs z/OS as it's operating system capable of handling millions and trillions of transaction with a zero down, crucible for running mission critical applications in banking, insurance, telecommunications, health care and government federal military domain. the lack of mainframe skill and misconception of mainframe being at the end of it's lifespan due to a wrong belief of soon to be replaced by a modern system has created a huge in the dependency to run business and the adequate skills required to support the system. Hence today I will be discussing and learn about JCL (Job Control Language), which is the script of any application system catering to a specific purpose to business continuity. Any system is chain/sequence of programs executing in synchronous manner with a various input/output operation to get the desired result. hence it becomes ma

Sort JCL in Descending Order and Format the output

Image
JCL sort is IBM utility used for sorting input data source such as PS, VSAM or SMS files. In this example I will demonstrate on How to Sort the Sequential Data set in Descending order and in the last, format the record in such a way that we will only get the selected column values in the output file JCL: This JCL executes SORT program in 2 steps Step01 - sorts the input file in Descending Order Step02 - copy the input file in output while in specified Format only. //* THIS JCL SORTS THE OUTPUT FILE IN DESCENDING ORDER       //* AND FORMATS THE OUTFILE                                  //STEP01   EXEC PGM=SORT                                     //SYSOUT   DD SYSOUT=*                                       //SORTIN   DD DSN=G101105.CLAIM.EXTRACT1,DISP=SHR            //SORTOUT  DD DSN=G101105.CLAIM.SORTED,                      //         DISP=(NEW,CATLG),UNIT=SYSDA,                      //         SPACE=(CYL,(100,100),RLSE),                       //         DCB=(LRECL=135,RECFM=FB,BLKSIZE=

Fixing DB2 data for A Given table using Batch Program.

Image
Hi Mainframe, Batch programming is a very powerful process which helps process Millions of record from a input data source. An Input data source can be a VSAM dataset, SMS files or Database Such as DB2 or IMS.  In these Blog we will be studying the Batch Application to update DB2 database which is our source of data having bad column value in it.  Many a times while working on Application Development or Enhancement, there is an unwanted Initialize or Move Statement in the Application program which cause the Database to be update with wrong values. And it becomes important to Fix this. As the Above Database has impacted 1000's & 10,000's of record values it becomes impossible to update each record with correct field without a Batch module. To facilitate the Batch update, we have been provided with many a techniques to collectively select and update a output desired records. One of those techniques which is widely and commonly used by Application developer is the use of CURSO