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 is the difference between cursor and select statement?
What is db2 and what is the use of db2 optimizer?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
When do you specify the isolation level?
Mention the definition of cobol in varchar field.
Name the lockable units in DB2?
What is nvl in db2?
What is the use of commit in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
How is deadlock resolved?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is commit in db2?
What is the advantage in De-normalizing tables in DB2?
What is difference between isnull and coalesce?
Is db2 a programming language?