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 lock escalation?

2 Answers  


What is db2 stogroup?

0 Answers  


Where can you declare a cursor in a cobol-db2 program?

0 Answers  


What does an outer join do?

1 Answers   CTS,


What is a page?

2 Answers  






What is copy pending and check pending in db2?

0 Answers  


Describe what a storage group(STOGROUP) is?

2 Answers  


Write a query to retrive partial string.

2 Answers  


What are the full forms of spufi and dclgen and why are they used?

0 Answers  


What is db2 plan table?

0 Answers  


Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


wht is d/f between union and joins ?

2 Answers  


Categories