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 |
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is package versioning? Please give an example.
What is the difference between db2 and oracle?
What is with ur in db2?
what is REORG? what is the use?
Explain about open switch business continuity software?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
How many types of page locks can be held in db2?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What does the CHECK Utility do ?