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...


Is it mandatory to use DCLGEN? If not, why would you use it
at all?

Answers were Sorted based on User's Feedback



Is it mandatory to use DCLGEN? If not, why would you use it at all?..

Answer / abhisek

No,it is not mandatory to use DCLGEN,it is used by the pre-
compiler to validate the table names,view names and column
names during pre-compile.

Is This Answer Correct ?    7 Yes 0 No

Is it mandatory to use DCLGEN? If not, why would you use it at all?..

Answer / guest

Just an addition to the above answer. By using the DCLGEN,
the program would use correct data types and column lengths
which avoids stage 2 processing of predicates, if the data
types and lengths mismatched.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

Do we need cursor for Count(*)?

4 Answers   iGate,


How is a typical DB2 batch program executed ?

1 Answers  


how will you retrieve first record in table

1 Answers   UST,


What is a db2 package?

0 Answers  


how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,


What is EXPLAIN?

1 Answers  


Mention the various locks that are available in db2.

0 Answers  


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

1 Answers   CSI, CTS,


What is the difference between bind and rebind in db2?

0 Answers  


SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,


What's The Percentage Free Space ?

0 Answers   IBM,


Which component is responsible for db2 startup and shutdown?

0 Answers  


Categories