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 bind in db2?
Can we install 2 different versions of Db2 on same mainframe?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What do the initials DDL and DML stand for and what is their meaning?
How to fetch the uncommited data from table ?
What is lock contention?
What does an outer join do?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
how to identify the pseudo conversation by seeing the program
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM