Is ibm db2 free?

0 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

What is db2 instance?

0 Answers  

---

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 cursor stability and repeatable read isolation levels?

0 Answers  

---

can you use symbolic parameters in JOB?

5 Answers   IBM,

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

What is temporal table in db2?

0 Answers  

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---