Answer / s

SQLCA is a collection of variables that is updated after
the execution of the SQL statment.
The values in these variables tells if the SQL completed
successfully or not and for testing specific error
conditions.

SQLCODE, SQLSTATE, SQLERRD(3)

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

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  

---

What is a collection?

3 Answers  

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

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 do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

---

What is the role of the data page in the db2 database?

0 Answers  

---

How will you delete duplicate records from a table?

7 Answers   Google,

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---

can any one expalin check point with an example?

1 Answers  

---

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---