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

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,


What is a db2 tablespace?

0 Answers  


What is dpf in db2?

0 Answers  


Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  


Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,


What kind of database is db2?

0 Answers  


What is the use of runstats in db2?

0 Answers  


What do the initials DDL and DML stand for and what is their meaning?

2 Answers  


How to define the a field which accepts value till 99999.99 in db2

3 Answers  


what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,


How do you check for a null value in a db2 column?

2 Answers  


What are the functions of Bind?

2 Answers   Amdocs, IBM,


Categories