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 oracle and db2?
What is the use of dclgen in db2?
Mention data types used in db2 ?
When the like statement is used?
What is declare cursor?
What is the difference between cursor stability and repeatable read isolation levels?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What are the contents of dclgen?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Which components manage deadlocks in db2?
What is the use of db2?
What is a db2 schema?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What are the uses of db2 optimizer?
What is table space in db2?