Interested to Buy Any Domain ? << Click Here >> for more details...
Can SQL statements/queries be included in a copybook?
- 2 Answers
- 7880 Views
- I also Faced
- E-Mail Answers
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 access db2 tables in mainframe?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
max number of columns in a db2 table?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
What is correlation names?
What is clone table?
How do I start db2 in windows?
if i made sme changes in sub pgm wht r the things to be done for this ?
What is SPUFI?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What is copy pending and check pending in db2?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
COBOL 
