Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

---

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

What else is there in the PLAN apart from the access path?

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,

---

Explain the EXPLAIN statement?

1 Answers  

---

What is meant by union and union all?

0 Answers  

---

Is db2 a programming language?

0 Answers  

---

What is the syntax for creating a table in the db2 database?

0 Answers  

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

What do you mean by rollback?

0 Answers  

---