Answer / rockys

Can be used ONLY with cursor

Answer / sunil

there should be no duplicates in the tables.

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

---

what is load and unload in db2

1 Answers   IBM,

---

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---

What is dynamic SQL?

1 Answers   ADP,

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

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  

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,

---

What is meant by explain?

0 Answers  

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

What is db2 connect?

0 Answers  

---