what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

What is dbrm library?

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 FREE command?

1 Answers  

---

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

1 Answers   TCS,

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

What do you mean by storage group (stogroup)?

0 Answers  

---

Explain various types of locks in db2?

0 Answers  

---

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  

---

what is datacom db?

2 Answers   CSC,

---

What os does db2 run on?

0 Answers  

---