My cobol program(not having any sql statements) is calling
another cobol program ( having sql statements), what is
needed for compilation and run in jcls .
Answers were Sorted based on User's Feedback
Answer / santy
Hi,
Lets consider the name the calling prg. as PROG1 and
called prg. as PROG2, Pgm PROG1 should be compiled as a
normal CBL pgm, and Pgm. PROG2 should be compiled as a
CoBoL-DB2 pgm. And the Run JCL should call the PGM PROG1,
using IKJEFT01 pgm, since it calls pgm PROG2 with SQL
statements. For the JCL u can refer to the JCLS link in the
same website
| Is This Answer Correct ? | 11 Yes | 4 No |
How do I import a csv file into db2?
What is buffrpool? Where we use it ?
What is the difference between Where and Having Clause
what are bind concepts in db2 cobol?
What do you do to keep the cursor from closing after a commit?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What is temporal table in db2?
What is db2 catalog database?
How to resolve -504 sql code in DB2?
What is Reorg Recovery? when will you run it?
What can the SET option of the Repair Utility accomplish?