Apart from reading forward, VSAM KSDS file can be read Backwards starting from a specified Key value. READPREV command is used for this purpose. To read a record in reverse order starting from a key needs to establish a starting point first which can be done using STARTBR, then READNEXT and READPREV does the backwards
VSAM Share Options defines the VSAM datasets accessibility among different users. Share options are like the DB2 locking system, by using these options different levels of shared access can be given to different jobs/users on a single VSAM dataset. Where to Set these options? Can be set while defining the VSAM cluster using IDCAMS. These
Restart Logic in COBOL DB2 Program: Restarting a program when it has abended after processing some number of records becomes necessary many times as it would be waste of resources to process them again. Rolling back the processed records is also a headache if there is no logic to start the program from the next
JCL SPACE Parameter is one of the important parameters to be specified for a NEW dataset which request the storage required for that dataset on a Direct Access Volume. SPACE Parameter in JCL is an Optional Keyword parameter that indicates the OS, the amount of memory allocation needed for a dataset while creating it and
Below are the few Tricky ones faced at CapGemini. 1. I have 1000 steps in a cataloged procedure. I want to run only a few steps (say from 8th step to 16th Step). How this can be achieved? 2. A cobol db2 program takes a flat file as input and updates a DB2 table and
TIME Parameter in JCL is a Keyword parameter which indicates the Processor Time required to execute the job/step in a JCL. This can be used either in JOB or in STEP or in both the places. If it is specified in a JOB, it tells the systems that this job can use the specified amount
DB2 stored procedures mainframe–> Stored procedures are the programs that contains one or more SQL statements to perform a business functionality and can be called by any application with SQL call statements. These are ALSO considered as the programs that are compiled and stored in a DB2 server which can be called/INVOKED from any application
JCL DISP (Disposition) parameter is a Keyword parameter which is used to describe the status of a data set used in JCL to the OS. It indicates the OS on what should be done with the dataset after JOB/STEP termination. It has 3 sub parameters which indicates THE STATUS,Normal & abnormal termination ACTIVITIES of the
There are multiple ways of initiating a transaction in CICS. Initiating a transaction is nothing but running that transaction to start any process. Below are the different ways of transaction initiation process. 1. Entering the trans ID on native region. Example: If CST1 is the transaction ID to display the main customer details screen. Then
Symbolic Parameters in JCL Using Symbolic parameters in JCL/PROC is a good practice to modify any PROC parameters from the JOB. This method gives the flexibility of using different parameters in Different jobs which are using a single PROC. It is not only used to modify the proc parameters, it can also be used in
