When will you chose to run RUNSTATS?

1 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What is db2 isolation?

2 Answers  

---

What is difference between isnull and coalesce?

0 Answers  

---

What are the rules for db2 programming?

0 Answers  

---

what is a collection?

2 Answers  

---

What is the physical storage length of time data type?

0 Answers  

---

What is filter factor?

2 Answers  

---

Can you Average the Characters ?

3 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

Name some fields from SQLCA

1 Answers  

---

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

---