Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

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

1 Answers   HCL,

---

Is ibm db2 open source?

0 Answers  

---

What are column-name qualifiers used?

1 Answers  

---

What are the Isolation levels possible ?

5 Answers  

---

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  

---

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

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,

---