- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to execute a COBOL-DB2 program PROGA of plan PLANA?
The COBOL-DB2 program can be executed with the help of IKJEFT01. The IKJEFT01 is an inbuilt mainframe utility that allows us to run z/OS TSO commands via Job control language(JCL). If we want to execute a COBOL-DB2 program PROGA of plan PLANA we must give a JCL step as below.
//STEP010 EXEC PGM=IKJEFT01 //STEPLIB DD DSN=DIS.TEST.LOADLIB,DISP=SHR //SYSOUT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(TB3) RUN PROGRAM (PROGA) PLAN(PLANA) END /*
In the above JCL step, we have first used IKJEFT01 utility to call the COBOL-DB2 program. The loadlib path for the program PROGA is given in STEPLIB i.e. DIS.TEST.LOADLIB and the location to print the program logs are mentioned in SYSOUT, which is spool in this case (SYSOUT=*). Then we have used SYSTIN to give the run-time parameters like DB2 database identifier (TB3), given by DSN SYSTEM and program/plan name.
It is necessary to give a plan with the program because it gives DB2, the access path information for the queries used in programs. The DB2 then follows this access path within the database to extract the data required in the program.
- How to precompile a COBOL-DB2 program?
- Steps involved in compilation of a COBOL-DB2 program
- Implementation of restart logic in a COBOL-DB2 program
- How to BIND all the packages in a collection COLLA to a plan PLANA?
- How to store a NULL value in a particular column of a DB2 table using COBOL-DB2 program?
- Purpose and usage of SAVEPOINT in COBOL-DB2 program
- Impact of database downtime on the COBOL-DB2 program
- How NON-REPEATABLE READ & PHANTOMS impact functioning of a COBOL-DB2 program?
- How to get the list of all COBOL-DB2 programs using a DB2 table TAB1?
- How can you revert all the DB2 table changes done in a COBOL-DB2 program?
- Implementation of a table level locks in a COBOL-DB2 program during program execution
- How to use SQLCA in a COBOL-DB2 program? What is the purpose of SQLCA?
- Behaviour of a COBOL-DB2 program when number of locks exceed the limit
- How LOST UPDATE and DIRTY READ impact the processing of a COBOL-DB2 program?
- How can a COBOL-DB2 program call a STORED PROCEDURE? Give an example.