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

What is runstats utility in db2?

0 Answers  


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


What is the purpose of rollback and commit?

0 Answers  


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

0 Answers  


select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,


What can the Locate option of the Repair Utility accomplish?

2 Answers  


Return code 100 means?

6 Answers   Cap Gemini,


What is the difference between static and dynamic SQL?

1 Answers  


What is an asychronous write?

1 Answers  


If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,


how can i pull up a query which was previously stored in qmf

3 Answers  


What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,


Categories