If a non-DB2 program calls a DB2 program, the calling program's name will

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?

Question Posted / shefali799

1 Answers
13855 Views
RBS, I also Faced
E-Mail Answers

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 ?

20 Yes

0 No

Post New Answer

More DB2 Interview Questions

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers

What is buffrpool? Where we use it ?

2 Answers Tesco,

What is blu acceleration in db2?

0 Answers

What is a storage group (stogroup)?

0 Answers

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers

What is the use of predicate?

0 Answers

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers ADP,

Which one allows duplicate values Union or Union All ?

3 Answers

how to get duplicate records from tables?write qurey for this?

4 Answers ANZ,

How to find the maximum value in a column in the db2 database?

0 Answers

What is db2 bind?

0 Answers

explain about index with examples

2 Answers Syntel,

For more DB2 Interview Questions Click Here