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



My cobol program(not having any sql statements) is calling another cobol program ( having sql stat..

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 cobol program(not having any sql statements) is calling another cobol program ( having sql stat..

Answer / vidhya

Db2card should be added in the calling program

Is This Answer Correct ?    0 Yes 1 No

My cobol program(not having any sql statements) is calling another cobol program ( having sql stat..

Answer / mangesh

Thanks Santy for all the answers .

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More DB2 Interview Questions

Mention data types used in db2 ?

0 Answers  


What is null indicator in db2?

0 Answers  


What is a DB2 bind?

3 Answers  


why we create view.

5 Answers  


Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,


What are common abends

1 Answers   SPIC, Virtusa,


Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  


Explain about cursor stability?

0 Answers  


What are the functions in DB2?

3 Answers   Satyam,


I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  


1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,


Which one allows duplicate values Union or Union All ?

3 Answers  


Categories