Answer / s

Read-only cursor is a cursor that is defined with FOR FETCH
ONLY clause. The curosor is defined with SELECT, SELECT
INTO.

Can SQL statements/queries be included in a copybook?

2 Answers  

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

What is read-only cursor?

1 Answers  

---

What parameters are used to control the free space in DB2?

0 Answers  

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

cursor with hold explain ?

1 Answers   Verizon,

---

How can the duplicate values be eliminated from db2 select?

0 Answers  

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

List down the types of triggers in the db2 database?

0 Answers  

---