The only place of VSAM KSDS in DB2 is?

2 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  

---

Can there be more than one cursor open for any program?

0 Answers  

---

How and when does the db2 enforces the unique key?

0 Answers  

---

What is a collection?

3 Answers  

---

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,

---

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

---

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

2 Answers  

---