What type of database is 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,

---

Describe major components of db2?

0 Answers  

---

Are view updateable?

0 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

---

What is the use of with ur in db2?

0 Answers  

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

pls tell me abt the normalization five types....

2 Answers  

---

How to create a table using embedded sql?

1 Answers  

---

What does DML stand for and what are some examples of it?

3 Answers   IBM,

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

---