How would you find out the total number of rows in a db2 table?

0 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

What is check constraint. Explain with example.

0 Answers  

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

Can one database have multiple instances?

0 Answers  

---

What is a lock?

1 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

Mention the definition of cobol in varchar field.

0 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

What is isolation level in db2?

0 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---