Can SQL statements/queries be included in a copybook?

Answer Posted / ekalavya

The DB2 related things have to be included with the pre
compiler directive
EXEC SQL
INCLUDE XYZ
END-EXEC
But not like COPY XYZ.

This is because COPY statements are expended during
Compilation step, but the DB2 related items should be
available in pre-compilation step inorder to create DBRM
module, which is the input for Binding process into
PLAN/PACKAGE.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is db2 command?

582


What is image copy in db2?

566


What are iseries servers?

566


How can you count the number of rows from a table tab?

633


What is the syntax for seeing the columns and data types of a table in the db2 database?

576






What is package in db2 mainframe?

555


Why do we need reorg in db2?

558


What is db2 purescale?

543


What is catalog database in db2?

640


What's The Error Code For Unique Index Voilation?

648


What is the use of value function?

622


What is the syntax for FETCH in DB2 ?

671


Explain the function of data manager.

632


How and when does the db2 enforces the unique key?

613


What is lock escalation in db2?

572