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

What is the use of db2 optimizer?

617


How to check table size in db2 sap?

589


Why select is not preferred in embedded sql programs?

717


What is a db2 schema?

766


What is nvl in db2?

634






Why do we need reorg in db2?

569


What is the usage of open cursor command?

605


What is ibm db2 used for?

608


How connect db2 database to datastage?

773


What is the maximum No of rows per page?

634


What parameters are used to control the free space in DB2?

648


What is meant by dclgen?

623


How does coalesce work?

591


What r the comman abends in db2, jcl and cobol???????

1823


what are bind concepts in db2 cobol?

654