Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is sql abend code -801,-802?




1480
views
asked mar August 3, 2014 07:07 AM  

What is sql abend code -801,-802?


           

1 Answers



 
answered By Mswami   0  
-802

Explanation:

An exception error has occurred in the processing of an SQL arithmetic function or arithmetic expression. The exception error occurred in one of the following areas:

In the SELECT list of an SQL SELECT statement.
In the search condition of a SELECT, UPDATE, MERGE, or DELETE statement.
In the SET clause of the UPDATE operation.
During the evaluation of an aggregate function.
Parts of exception-type, operation-type, data-type, and position-number might not be returned to the SQL communication area, depending on where the error was detected.

exception-type:
Indicates the type of error.
Possible values for exception-type are:

  • FIXED POINT OVERFLOW
  • DECIMAL OVERFLOW
  • ZERO DIVIDE
  • DIVIDE EXCEPTION
  • EXPONENT OVERFLOW
  • INVALID OPERATION
  • SUBNORMAL
  • UNDERFLOW
  • OVERFLOW
  • OUT OF RANGE

operation-type:
Indicates the operation that was being performed at the time of the error. Possible operation-type includes the following arithmetic operations:
  • ADDITION
  • SUBTRACTION
  • MULTIPLICATION
  • DIVISION
  • NEGATION
operation-type might also be one of the following operations:

Programmer response:

Examine the SQL statement to see if the cause of the problem can be determined. The problem might be data-dependent, in which case it will be necessary to examine the data that was being processed at the time the error occurred.

If the arithmetic expression in error was within the SELECT list of the outer SELECT statement, it is advisable to include an indicator variable for all expressions in the SELECT list. This allows processing to continue so that non-error column and expression values can be returned.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert