Answer / s

You can use TSO to run a batch program using the TSO
Terminal Monitor Program IKJEFT01 which involes the DSN
command and runs the application program.

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

What is a DB2 catalog?

2 Answers  

---

How can you count the number of rows from a table tab?

0 Answers  

---

What is image copy in db2?

0 Answers  

---

How do we specify index to include or not during bind process.

0 Answers   Satyam,

---

Explain transactions, commits and rollbacks in DB2.

3 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

How do you retrieve the data from a nullable column?

2 Answers  

---

What is collection in db2 bind?

0 Answers  

---

is there any restrictions for unions ?

4 Answers   Patni,

---

What is a view? Why use it?

3 Answers  

---