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 Posted / 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 View All Answers
What does db2 plan contain?
Comment whether the cursor is closed during commit or not.
What is the syntax for FETCH in DB2 ?
What is a plan and package in db2?
When the like statement is used?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is db2 catalog database?
What db2 400?
What is difference between alias and synonym in db2?
How do I optimize a query in db2?
Explain about rct in db2?
Give the name of some fields form sqlca.
Explain the contention situations caused by locks?
What is the usage of open cursor command?
What are the various data types available in db2?