Answer / lu

first of all, i suggest you to read errors messages if you
get any error before asking (always learning
yourself) ...in db2 you have a lot...a lot error....
now
sqlcode = -801, -802 it's mean you try to divide your
column by zero....

Answer / yuvaevergreen

-802
Possible values for exception-type are FIXED POINT
OVERFLOW, DECIMAL OVERFLOW, ZERO DIVIDE, DIVIDE EXCEPTION,
EXPONENT OVERFLOW, or OUT OF RANGE.

Explain what are the various isolation levels possible?

1 Answers  

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

What is cursor with hold option in db2?

1 Answers  

---

How many types of page locks can be held in db2?

1 Answers  

---

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

2 Answers  

---

Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  

---

How do I delete a table in database?

1 Answers  

---

What is alias in db2?

1 Answers  

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

What is query_cache_limit?

1 Answers  

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---