Answer / rahul

1 to 64

Answer / s

The maximum number of partitions allowed in DB2 V8 is 4096
partitions.

What is the meaning of -805 SQL return code?

3 Answers  

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,

---

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  

---

What are concurrency issues?

1 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

How to create a table using embedded sql?

1 Answers  

---

What is image copy?

1 Answers   Virtusa,

---

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

---

How do I copy a table in db2?

1 Answers  

---

What is bind plan?

1 Answers  

---