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 default page size of buffer pools?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
Can a array declared with an index be displayed(readable format) in spool?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is drop table?
What is Declaration Generator(DCLGEN)?
What do the initials DDL and DML stand for and what is their meaning?
How can you split a table in to exactly half?
What language is db2 written in?
What is a db2 table?
What are the four lockable units for DB2?