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 and when does the db2 enforces the unique key?
What are host variables in db2?
What is buffer pool?
What is deadlock in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is collection in db2 bind?
What are the various data types available in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is innodb buffer pool?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What are the full forms of spufi and dclgen and why are they used?
What is the clustering index in the db2 database?
What are db2 objects?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?