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 to execute stored procedure in db2 command editor?

984


How can you find out the # of rows updated after an update statement?

1050


What is dbrm in db2 database?

1032


How to resolve deadlock issue

19862


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2865


Mention data types used in db2 ?

1105


Why select is not preferred in embedded sql programs?

1228


What is an instance database?

1004


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1017


What is the purpose of using commit?

1040


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1102


What is the physical storage length of date data type?

1189


What is the use of value function?

1074


Is db2 a programming language?

983


What is db2 bind process?

1179