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,

---

what is datacom db?

2 Answers   CSC,

---

What do you mean by commit and rollback?

0 Answers  

---

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---

What will the DB2 optimizer do?

2 Answers  

---

What is the function of logging in the db2 database?

0 Answers  

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

---

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  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---

What is the use of commit in db2?

0 Answers  

---

max number of columns in a db2 table?

6 Answers  

---