What is iseries database?

0 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

What is the self-referencing constraint?

2 Answers  

---

Give a brief description of db2 isolation levels?

0 Answers  

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

What happens in bind step in a db2 program?

0 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

Give some example of statistics collected during RUNSTATS?

1 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---

What are the advantages of using a PACKAGE?

2 Answers  

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---