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 the reason behind not using select * in embedded sql programs?
What is the use of value function?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is the difference between drop table and delete table?
How do you stop a db2 database in linux?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What Utility is used to migrate DB2 from one release to the next?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What are the functions in DB2?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
what is difference between random and sequence file access