what is sql abend code -801,-802?
Answers were Sorted based on User's Feedback
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....
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / yuvaevergreen
-802
Possible values for exception-type are FIXED POINT
OVERFLOW, DECIMAL OVERFLOW, ZERO DIVIDE, DIVIDE EXCEPTION,
EXPONENT OVERFLOW, or OUT OF RANGE.
| Is This Answer Correct ? | 8 Yes | 2 No |
What is the advantage in De-normalizing tables in DB2?
What is db2 connect?
What is ibm db2 used for?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What is concurrency?
What is a LIKE table and how is it created?
Can we update view in db2?
What is sqlca?
what is the difference between normal select query and currosor
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
What is the significance of DB2 free space and what parameters control it?
what are bind concepts in db2 cobol?