Which one allows duplicate values Union or Union All ?

3 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

---

What is the meaning of -805 SQL return code?

3 Answers  

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

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  

---

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

---

How do you check for a null value in a db2 column?

2 Answers  

---

What is a collection?

3 Answers  

---

What is deadlock?

2 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---