Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql abend code -801,-802?
- 2 Answers
- 27145 Views
- I also Faced
- E-Mail Answers
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 |
How many sub queries can you combine together ?
How to fetch the uncommited data from table ?
What is isolation level?
How do you insert a record with a nullable column?
How does cobol compile db2 program?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is host variable?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What is the role of schema in the db2 database?
Mention the various locks that are available in db2.
On which levels locks can be applied?
Explain transactions, commits and rollbacks in DB2.
COBOL 
