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 |
Mention data types used in db2 ?
What is null indicator in db2?
What is a DB2 bind?
why we create view.
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.
What are common abends
Is DECLARE TABLE in DCLGEN necessary? Why it used?
Explain about cursor stability?
What are the functions in DB2?
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?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
Which one allows duplicate values Union or Union All ?