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 |
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
what is a plan and how do you refer the plan in the program?
Before you give the explain statement, what are the prerogatives?
What are column-name qualifiers used?
How and when does the db2 enforces the unique key?
where can we use index and subscript ? with example ?
How can deadlocks be resolved?
How does coalesce work?
What is the max length of sqlca?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
Can we use select * statement in cobol program without giving field names ???