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 / 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 |
What is lock escalation?
What is db2 stogroup?
Where can you declare a cursor in a cobol-db2 program?
What does an outer join do?
What is a page?
What is copy pending and check pending in db2?
Describe what a storage group(STOGROUP) is?
Write a query to retrive partial string.
What are the full forms of spufi and dclgen and why are they used?
What is db2 plan table?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
wht is d/f between union and joins ?