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
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Explain in brief how does db2 determine what lock-size to use?
Explain package in db2 and its advantages?
What is the syntax for FETCH in DB2 ?
What is iseries database?
How to access db2 tables in mainframe?
Explain db2.
What is the use of predicate?
What is db2? Explain.
What is the use of reorg in db2?
What is a plan and package in db2?
define clustering index.
Which component is used to execute the sql statements?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is rct?