Answer / madhavi chava

As definition of cursor is non executable statement, it is
advisable not to define in procedure division as it may
misunderstood others.

we can define it any where only thing you have to take care
is definition of cursor should be prior to the OPEN
statement of the same cursor.

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

Where is the output of EXPLAIN stored?

2 Answers  

---

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers   Syntel,

---

How is a typical DB2 batch program executed ?

1 Answers  

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

how will you retrieve first record in table

1 Answers   UST,

---

What is ibm db2 used for?

0 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

What is meant by the attachment facility?

3 Answers  

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---