how to fetch multiple records without using cursor

14 Answers   HCL,

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

Which catalog tables contain authorization information?

1 Answers  

---

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,

---

Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

What is PRIME TABLE and what are the uses of it

1 Answers  

---

What is an instance database?

0 Answers  

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

What is the purpose of the QUIESE Utility?

1 Answers  

---