Can SQL statements/queries be included in a copybook?
- 2 Answers
- 6833 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 |
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
Can any one tell me about Restart logic in DB2.
What are the prerogatives?
On the create tablespace, what does the CLOSE parameter do?
What is the usage of open cursor command?
Why do we bind in db2?
What is the role of the data page in the db2 database?
How do I delete a table in db2?
What is db2 bind?
What is release/acquire in bind?
What are packages in db2?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
COBOL 
