Interested to Buy Any Domain ? << Click Here >> for more details...
Can SQL statements/queries be included in a copybook?
- 2 Answers
- 7905 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 a db2 collection?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
what is db2 restart?
how can we find nth max salary from A table
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
how to identify the pseudo conversation by seeing the program
How to retrieve rows from a db2 table in embedded sql?
how to check the table is empty or not?
On the create tablespace, what does the CLOSE parameter do?
Explain what are the various isolation levels possible?
i want to delete 20th million record how ?
COBOL 
