Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql abend code -801,-802?
- 2 Answers
- 27257 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 |
What is alias in db2?
What are the four lockable units for DB2?
How does db2 sample database connect?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What types of tables are there in the db2 database?
How can you find out the # of rows updated after an update statement?
why we create view.
what is + sign and -ve sign for sql code ?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
How many buffer pools are available in db2?
What is the SQL Communications Area and what are some of its key fields?
My SQL is not performing well. Describe how will you fine tune it?
COBOL 
