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?



If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN o..

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

Post New Answer

More DB2 Interview Questions

What is the significance of DB2 free space and what parameters control it?

1 Answers  


What is explain in db2?

0 Answers  


wht displays the number of times a query modified ?

2 Answers   TCS,


What is the difference between static and dynamic SQL?

1 Answers  


What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,


Explain in detail about buffer manager and its functionalities?

0 Answers  


What is the physical storage length of time data type?

0 Answers  


what is the difference between join and union?

4 Answers   IBM,


What is the difference between db2 and oracle?

0 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,


Categories