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 are some characteristics of columns that benefit from indexes?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What do you do to keep the cursor from closing after a commit?
What is universal database?
What is database reorganization?
What is a clustering index ?
What language is db2 written in?
What is a db2 package?
What is with ur in db2?
What is the format (internal layout) of ?TIMESTAMP??
What is reorg and runstats in db2?
How many sub queries can you combine together ?