Can SQL statements/queries be included in a copybook?
- 2 Answers
- 7221 Views
- I also Faced
- E-Mail Answers
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
Describe major components of db2?
Why do chiropractors use drop table?
What is a buffer in memory?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is dbrm?
What is the maximum size of varchar data type in db2?
How to find the maximum value in a column in the db2 database?
What is the role of union all and union
What is database reorganization?
How many types of page locks can be held in db2?
Explain about rct in db2?
Give a brief description of db2 isolation levels?
Explain the contention situations caused by locks?
What is dbrm? What it contains? When it will be created?
What is db2 catalog database?
