What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

What is ibm db2 used for?

0 Answers  

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---

What is a thread?

3 Answers  

---

What is database reorganization?

0 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

Where would you find information about the type of database authority held by the user?

2 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

Which command is used to remove all rows from a table?

0 Answers  

---

What is query_cache_limit?

0 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

---