Answer / s

Column name qualifier is Table name

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

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,

---

Why do chiropractors use drop table?

0 Answers  

---

Update command

1 Answers  

---

Mention data types used in db2 ?

0 Answers  

---

How is a typical DB2 batch program executed ?

1 Answers  

---

What is the max length of sqlca?

0 Answers  

---

What is the purpose of using commit?

0 Answers  

---

What is the clustering index in the db2 database?

0 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---