Answer / s

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

List down the data types in the db2 database.

0 Answers  

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

What is a cursor and what is its function?

2 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

---

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

What is consistency token in db2?

0 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 explain plan in db2?

0 Answers  

---

What is a dbrm in db2?

0 Answers  

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---