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 |
How to create a table using embedded sql?
What language is db2 written in?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is a composite index and how does it differ from a multiple index?
What is the meaning of -805 SQL return code?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
what is the use of bind parameter, Replace?
What is the syntax required for the creation of a cursor?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What do you need to do before you do EXPLAIN ?
How do you pull up a query which was previously saved in qmf?
Can you define an Index if the table size less than 10 PAGES?