Answer / vaneesh khurana

When you are fetching cursor without declaration.

Answer / purushothr

Yes it is possible only in cursor. if u trying to retrieve
more than one row at the same time by using cursor then -
811 error ll come.

What are the disadvantages of using VARCHAR?

3 Answers  

---

When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,

---

select 100 records from million records ?

2 Answers   Verizon,

---

Name some fields from SQLCA

1 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

---

How do I import a csv file into db2?

0 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

Where would you find information about the type of database authority held by the user?

2 Answers  

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

What are the various isolation levels possible?

0 Answers  

---

Explain what are the various isolation levels possible?

0 Answers  

---