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 Static and dynamic linking
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
What is a db2 schema?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
wht are the restrictions for union ?
what's the error code for Unique Index Violation?
What is the default page size of buffer pools?
What is reorg in database?
Explain the EXPLAIN statement?
What is the difference between drop table and delete table?
Which component is responsible for db2 startup and shutdown?
What is null in db2?