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
Answer / sudi
No Plan needs to be created for the Non-DB2 program. The
SYSTIN should be as below:
RUN PROGRAM(Non-DB2 Program name) PLAN(DB2 PROGRAM NAME)
|Is This Answer Correct ?||18 Yes||0 No|
What is the purpose of the WHENEVER statement?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
what is SMP/E? and what are the major steps of it? thanks...
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
How is the value function used?
What is a dbrm in db2?
explain about index with examples
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
How many types of page locks can be held in db2?
Name some fields from SQLCA.
What is the use of reorg in db2?