Can SQL statements/queries be included in a copybook?
- 2 Answers
- 7220 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 |
What is difference between alias and synonym in db2?
What is the maximum length of sqlca?
What information is contained in a SYSCOPY entry?
What are the contents of dclgen?
How many Buffer pools are there in DB2 and what are they?
What is the difference between bind and rebind in db2?
How can you do the explain of a dynamic sql statement?
wht steps we need will coding cobol and db2 pgm ?
Which is faster delete or truncate?
How do you stop a db2 database in linux?
Can we delete records from view?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
COBOL 
