Interested to Buy Any Domain ? << Click Here >> for more details...
Can SQL statements/queries be included in a copybook?
- 2 Answers
- 7995 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 |
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
cobol-db2 runjcl please?
What is the syntax for FETCH in DB2 ?
What is COPY PENDING status?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are the three DB2 date and time data types and their associated functions?
What is difference between isnull and coalesce?
how can we find nth max salary from A table
What kind of database is db2?
What is meant by concurrency?
What is the use of dclgen in db2?
COBOL 
