- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What will be the result if DCLGEN is given with COPY statement and not INCLUDE?
The main difference between INCLUDE and COPY statement is the PDS member with INCLUDE statement is expanded during pre-compilation while the PDS member with COPY statement is expanded during compilation.
Since the DCLGEN member contains column names of the table (table structure) it is necessary to expand it during the pre-compilation. This is because at the time of precompilation all the SQL statements are validated, placed in DBRM and finally replaced by appropriate COBOL calls.
If the DCLGEN members are given with COPY statement instead of INCLUDE statement, then it will result in DB2 warnings during pre-compilation as the pre-compiler would not be able to validate the SQL statements in COBOL-DB2 program.
Updated on 14-Sep-2020 11:01:31
- Related Questions & Answers
- What will be the result if SQLCA is not included in a COBOL-DB2 program?
- How will the COBOL-DB2 program behave if the DCLGEN member is not included?
- What will be the result if there is a timestamp mismatch in the DBRM and Load module?
- What will happen if a NULL value is detected for a SQL statement in COBOL-DB2 program and the NULL indicator is not used?
- PHP include Statement
- What happens if I will prepare the statement with the same name without de-allocating the earlier one?
- What is the difference between include action and include directive in JSP?
- What is the if...else statement in JavaScript?
- What is if statement in JavaScript?
- What is if...else if... statement in JavaScript?
- What is the resemblance of COALESCE() function with IF-THEN-ELSE statement?
- In function INSERT(str, Pos, len, newstr), what would be the result if ‘Pos’ is not within the length of the string?
- How will be the world if currency(money) is removed from our lives?
- If Google and Yahoo merged, what do you think will be the name of the new company?
- What will happen to MySQL current transaction, if in the middle of that transaction, the DDL statement is executed?
Advertisements