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


Please Help Members By Posting Answers For Below Questions

How do you select a row using indexes in db2?

633


What is the role of union all and union

640


What is dbrm? When it will be created?

582


How to test SQL -911 error while developing COB-DB2 program

6684


What is the difference between cursor and select statement?

605






Why do chiropractors use drop table?

645


How to resolve deadlock issue

17901


What do you mean by between and in? Is between inclusive of specified range values?

650


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

564


What is the reason behind not using select * in embedded sql programs?

593


What is ibm db2 used for?

590


What is the role of data manager in the db2 database?

631


What is a page in db2?

596


What is the difference between spufi and qmf?

629


Define declaration generator (dclgen).

654