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 |
What is the purpose of the WHENEVER statement?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is commit in db2?
Is db2 a mainframe database?
What is the result of open cursor statement?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
How to fetch the uncommited data from table ?
What does an outer join do?
how to get duplicate records from tables?write qurey for this?
What is JOIN and different types of JOIN.
What is package in db2 mainframe?
i have a db2 variable how do u declare tht into working storage section ?