Can SQL statements/queries be included in a copybook?
Answers were Sorted based on User's Feedback
Answer / tom
Yes, if the copybook is included with the precompiler
directive EXEC SQL INCLUDE. No, if one attempts to include
the copybook with a COBOL COPY directive.
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / 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 |
How to find the maximum value in a column in the db2 database?
What is index in db2?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
Explain db2.
what is the difference between join and union?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
Give the name of some fields form sqlca.
pls explain the precompilation process of cobol-db2 pgm
What are the full forms of spufi and dclgen and why are they used?
What is tablespace?
Explain what a plan is?
What is cursor with hold option in db2?