Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---

What is cobol db2?

0 Answers  

---

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

What is meant by repeatable read?

4 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  

---

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---

Name some fields from SQLCA

1 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---