What is the FREE command?

1 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

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  

---

max number of columns in a db2 table?

6 Answers  

---

Define data page.

0 Answers  

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,

---

When reorg is used?

0 Answers  

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,

---