Can SQL statements/queries be included in a copybook?
- 2 Answers
- 7307 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 |
Explain correlated sub-queries.
How to select the duplicate rows from a table?
What is a correlated sub query?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
is it possible to get -811 error when you use cursors. why?
What is the use of dclgen in db2?
What is copy pending status in db2?
How to fetch the last row from the table in SQL (db2)?
What is the error code -803 ?
What is the function of the Data Manager?
Explain db2.
COBOL 
