Answer / vat

it depends :) which vesion of DB2 that you are referring
to...

V7 : 18
V8 : 30

Answer / roop

30

Answer / ragudeep

30 is the maximum length of the column name

Answer / pasha

always 18 only

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

3 Answers  

---

What is a page?

2 Answers  

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---

Why do we need reorg in db2?

0 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

---

What is QUIESCE?

2 Answers  

---

What is the syntax for creating a table in the db2 database?

0 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---