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 keyword does an SQL SELECT statement use for a string search?
What is copy pending and check pending in db2?
How will you return the number of records in table?
What does the REORG Utility do?
Name the lockable units in DB2?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
Why cursor is used in db2?
What are host variables in db2?
What type of database is db2?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
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?