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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

if any of the column names is provided wrong, where do you
get the error(during precompilation or during Bind)

Question Posted / ahmed

Answers were Sorted based on User's Feedback



if any of the column names is provided wrong, where do you get the error(during precompilation or d..

Answer / tej

The above answer is correct but not always.

If we use DECLARE TABLE in the program then the table and
columns names are validated in the pre-compilation step
itself.

Is This Answer Correct ?    5 Yes 0 No

if any of the column names is provided wrong, where do you get the error(during precompilation or d..

Answer / deepak dada, jaipur

Precompilation has got nothing to do with the column
checking, it is just the process of syntax checking and
separating the sql statements from the cobol program and
just prepares the dbrm.

actual process for db2 takes place in bind card

Is This Answer Correct ?    6 Yes 3 No

if any of the column names is provided wrong, where do you get the error(during precompilation or d..

Answer / shrik

u will face the error in Precompilation phase itself since
thats where DECLENGS are validated and DBRM is created.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

Do we need cursor for Count(*)?

4 Answers   iGate,

what is Static and dynamic linking

1 Answers   Virtusa,

Explain in detail about buffer manager and its functionalities?

0 Answers  

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  

What do you mean by storage group (stogroup)?

0 Answers  

What are catalog tables in db2?

0 Answers  

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

Explain the use of the WHERE clause.

2 Answers   IBM,

Give a brief description of db2 isolation levels?

0 Answers  

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

What is correlated subquery?

1 Answers  

what is rebinding ?

1 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories