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 check constraint. Explain with example.
What is performance tuning db2?
How would the varchar column remarks defined?
What is ibm db2 client?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the use of with ur in db2?
Explain what are the various isolation levels possible?
Why do we need reorg in db2?
What is the max length of sqlca?
How to check table size in db2 sap?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the difference between cursor stability and repeatable read isolation levels?
List out the three types of page locks that can be held.