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
13940 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 do you filter out the rows retrieved from a Db2 table ?

1 Answers

What is a SELECT statement?

1 Answers

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers UST,

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers

What is bind package and plan in db2?

0 Answers

what is the use of commit ? and what is the syntax?

2 Answers Deloitte,

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers IBM, scintel,

What is auditing?

2 Answers

what is the use of bind parameter, Replace?

5 Answers IBM,

Explain package in db2 and its advantages?