I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

What is phantom read in db2?

0 Answers  

---

What are common abends

1 Answers   SPIC, Virtusa,

---

What is the size of a data page?

2 Answers   IBM,

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

how to take the back up of the DB2 table.

7 Answers  

---

List out the buffer pools in db2

0 Answers  

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---