What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

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,

---

Can we insert update delete in view?

0 Answers  

---

What is the difference between cursor and select statement?

0 Answers  

---

What is performance tuning db2?

0 Answers  

---

---

What is auditing?

2 Answers  

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

What are the various data types available in db2?

0 Answers  

---

How to execute stored procedure in db2 command editor?

0 Answers  

---

What is page size in db2?

0 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---