How do I optimize a query in db2?

0 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

How can you classify the locks in db2?

0 Answers  

---

how 2 resolve the -311 sqlcode

1 Answers  

---

what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

---

What is the max length of sqlca?

0 Answers  

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

What is null in db2?

0 Answers  

---