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 significance of the CURSOR WITH HOLD clause in a cursor declaration?
what is difference between Static call and Dynamic call? How does it function?
What is tablespace?
How to create db2 table in mainframe?
What is the difference between cursor stability and repeatable read isolation levels?
What is cobol db2?
How do you filter out the rows retrieved from a Db2 table ?
What is the use of db2 optimizer?
What is scrollable cursor in db2?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,