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

2 Answers   Tech Mahindra, Wipro,

---

What does the sqlcode of -818 pertain to?

3 Answers  

---

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,

---

What is a collection?

3 Answers  

---

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

what is the use of bind parameter, Replace?

5 Answers   IBM,

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

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,

---