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

What is precompiler in db2?

1005


How can deadlocks be resolved?

928


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

1103


What is role in db2?

1099


How many databases are there?

1045


What is a bind card?

1209


Mention some fields that are a part of sqlca.

1014


What is db2 command?

1026


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1179


What is performance tuning db2?

1056


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3570


What is an instance database?

1043


What is a db2 package?

1042


What is the advantage in De-normalizing tables in DB2?

1162


What is the role of the data page in the db2 database?

1017