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 the purpose of rollback and commit?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Explain in detail about buffer manager and its functionalities?
What is lock escalation in db2?
What is dclgen in db2?
How to find schema of a table in db2?
What is view db2?
How many databases are there?
What is the use of reorg in db2?
When reorg is used?
is it compulsory commitment control in journal?
What is scrollable cursor in db2?
Discuss about db2 bind?
What is the use of dclgen in db2?
What is the result of open cursor statement?