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.

Mandalika

Published on 14-Sep-2020 11:01:05

• 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 is the difference between include action and include directive in JSP?
• What happens if I will prepare the statement with the same name without de-allocating the earlier one?
• What is the if...else statement in JavaScript?
• What is if statement in JavaScript?
• What is if...else if... statement in JavaScript?
• In function INSERT(str, Pos, len, newstr), what would be the result if ‘Pos’ is not within the length of the string?
• What is the resemblance of COALESCE() function with IF-THEN-ELSE statement?
• 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?
• How will be the world if currency(money) is removed from our lives?