If a non-DB2 program calls a DB2 program, the calling
program's name will be there in SYSIN of IKJEFT01 and the
plan name will be that of the called program. But is a bind
needed or a plan has to be created for the non-DB2 program
also?
Answer / sudi
No Plan needs to be created for the Non-DB2 program. The
SYSTIN should be as below:
DSN SYSTEM(XXXX)
RUN PROGRAM(Non-DB2 Program name) PLAN(DB2 PROGRAM NAME)
END
Is This Answer Correct ? | 20 Yes | 0 No |
What is the significance of DB2 free space and what parameters control it?
What is explain in db2?
wht displays the number of times a query modified ?
What is the difference between static and dynamic SQL?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
how to resolve -818 error. how to see timestamp token in load module and plan
Explain in detail about buffer manager and its functionalities?
What is the physical storage length of time data type?
what is the difference between join and union?
What is the difference between db2 and oracle?
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.