How does one remove entries from the SCT02 table?

1 Answers  

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 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 db2 purescale?

0 Answers  

---

What is referential integrity?

5 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

What is a view? Why use it?

3 Answers  

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

How to see the structure of db2 table??

4 Answers   IBM,

---

Which components manage deadlocks in db2?

0 Answers  

---