What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---

What is DB2 (IBM Database 2)?

3 Answers  

---

How many databases can be created inside an instance in db2 ?

0 Answers   MCN Solutions,

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

Which component is used to execute the sql statements?

0 Answers  

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  

---

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

3 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  

---

Which components manage deadlocks in db2?

0 Answers  

---

Give the COBOL definition of a VARCHAR field.

2 Answers  

---