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 |
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Explain db2.
What kind of database is db2?
What is the difference between IN subselects and EXISTS subselect?
How to find last record before record through SQLRPGLE?
What is isolation level?
What is explain in db2?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is the use of db2 optimizer?
select 100 records from million records ?
What is cursor in dbms?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?