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
How to execute stored procedure in db2 command editor?
How can you find out the # of rows updated after an update statement?
What is dbrm in db2 database?
How to resolve deadlock issue
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Mention data types used in db2 ?
Why select is not preferred in embedded sql programs?
What is an instance database?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the purpose of using commit?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the physical storage length of date data type?
What is the use of value function?
Is db2 a programming language?
What is db2 bind process?