Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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?



If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN o..

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 ?    18 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the purpose of the WHENEVER statement?

1 Answers  


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. 

2 Answers   RBS,


what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,


Define db2.

0 Answers  


If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  






How is the value function used?

0 Answers  


What is a dbrm in db2?

0 Answers  


explain about index with examples

2 Answers   Syntel,


Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,


How many types of page locks can be held in db2?

0 Answers  


Name some fields from SQLCA.

2 Answers  


What is the use of reorg in db2?

0 Answers  






Categories