Can SQL statements/queries be included in a copybook?
Answer Posted / ekalavya
The DB2 related things have to be included with the pre
compiler directive
EXEC SQL
INCLUDE XYZ
END-EXEC
But not like COPY XYZ.
This is because COPY statements are expended during
Compilation step, but the DB2 related items should be
available in pre-compilation step inorder to create DBRM
module, which is the input for Binding process into
PLAN/PACKAGE.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is precompiler in db2?
How can deadlocks be resolved?
Which command is used to remove all rows from a table?
What is role in db2?
How many databases are there?
What is a bind card?
Mention some fields that are a part of sqlca.
What is db2 command?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is performance tuning db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is an instance database?
What is a db2 package?
What is the advantage in De-normalizing tables in DB2?
What is the role of the data page in the db2 database?