If we keep the DCLGEN structure for a table in a copybook
and include it in the COBOL program using the COPY
statement, will there be any impact during compilation or
at any stage of program execution?
Answers were Sorted based on User's Feedback
Answer / ajay ahuja
DCLGENs are processed by Precompiler.
So instead of using COPY "DCLGEN Menber", it is required to
use INCLUDE "DCLGEN member".
This is because INCLUDE copybooks are being expanded during
Precompilation and COPY "Member" will be expanded during
compilation.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / tom
DCLGENs need to be processed by the precompiler. The
precompiler will comment out the SQL and insert the
appropriate COBOL definitions.
If the COPY directive is used, the COBOL compiler will flag
the SQL with syntax errors.
| Is This Answer Correct ? | 8 Yes | 0 No |
What is a DB2 plan?
What is the use of db2 optimizer?
Where would you find information about the type of database authority held by the user?
Is db2 a database?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Outputs of explain are with matchcols = 0. What does this signify?
What is a NULL value? What are the pros and cons of using NULLS?
What are types of indexes?
When is the authorization check on DB2 objects done - at BIND time or run time?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is the connection string to connect to the DB2 Database ?