How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

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  

---

How can we retrieve the total number of records in RPG & CLLE?

0 Answers  

---

What is a predicate?

1 Answers  

---

What do you need to do before you do EXPLAIN?

1 Answers  

---

Define predicate?

0 Answers  

---

When do you use the IMAGECOPY?

4 Answers  

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

What is the use of commit in db2?

0 Answers  

---

What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---