Interested to Buy Any Domain ? << Click Here >> for more details...
Can SQL statements/queries be included in a copybook?
- 2 Answers
- 7910 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 |
Are views updateable?
i want to maintain uniqueness on pdf without make lf??????????
What is db2? Explain.
Explain correlated sub-queries.
How can you compare table column after update and before update?
Do we need cursor for Count(*)?
What is IMAGECOPY ?
Mention the location where the output received from explain statement is stored.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to find last record before record through SQLRPGLE?
What is a db2 schema?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
COBOL 
