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 |
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What is PRIME TABLE and what are the uses of it
When will you chose to run RUNSTATS?
Comment whether the cursor is closed during commit or not.
What is an inner join, and an outer join ?
When is the skeleton cursor table created?
What is meant by the attachment facility?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
What is buffer pool and list some of them?
What is a base table?
how to resolve -818 error. how to see timestamp token in load module and plan
Are views updateable?