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 |
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
Which catalog table stores referential constraints?
Are view updateable?
Compare a subselect to a join?
What types of tables are there in the db2 database?
What is a DB2 catalog?
How to check sequence on a table in db2?
What is dclgen in db2?
Define predicate?
what is the input to PLAN? what is the input to DBRM?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
Highlight all the advantages that are attached to a package.