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 |
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
What is a db2 tablespace?
What is dpf in db2?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
Why use RUNSTAT Utility?
What kind of database is db2?
What is the use of runstats in db2?
What do the initials DDL and DML stand for and what is their meaning?
How to define the a field which accepts value till 99999.99 in db2
what is check point and restart Logic ? why do we go for that ??
How do you check for a null value in a db2 column?
What are the functions of Bind?