Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How do I add a column to a table in db2?

1104


What is the use of predicate?

1043


What is the role of schema in the db2 database?

1277


Which command is used to remove all rows from a table?

1113


What is db2 connect?

1078


What is database reorganization?

1130


What is drop table?

1016


How to rename a table in DB2 ?

1090


What is a db2 collection?

1052


What are the contents of a dclmgen?

1133


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

1093


What is db2?

1186


When the like statement is used?

1225


How do you pull up a query which was previously saved in qmf?

1153


What is collection in db2 bind?

1019