Interested to Buy Any Domain ? << Click Here >> for more details...
Can SQL statements/queries be included in a copybook?
- 2 Answers
- 7776 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 |
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
In terms of DB2 indexing, what is the root page?
How does db2 sample database connect?
How are write I/Os from the buffer pool executed?
How Plan is created while executing the query using SPUFI?
What do you mean by commit and rollback?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
Which isolation level provides maximum concurrency?
What is cursor stability in db2?
What is a synonym? How is it used?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
COBOL 
