SQL - SQLCODE's - Códigos positivos - +802


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode +802

   
 
  • Causa
    • EXCEPTION ERROR exception-type HAS OCCURRED DURING operation-type OPERATION ON data-type DATA, POSITION position-number

      The exception error exception-type occurred while doing an ADDITION, SUBTRACTION, MULTIPLICATION, DIVISION, NEGATION, or BUILT-IN FUNCTION operation on a field whose data-type is DECIMAL, FLOAT, SMALLINT or INTEGER.
      The error occurred while processing an arithmetic expression in the SELECT list of an outer SELECT statement, and the position in the select list is denoted by position-number.
      The possible exception types are FIXED POINT OVERFLOW, DECIMAL OVERFLOW, DIVIDE EXCEPTION, EXPONENT OVERFLOW, ZERO DIVIDE, or OUT OF RANGE.
      The data type displayed in the message may indicate the data type of the temporary internal copy of the data, which may differ from the actual column or literal data type due to conversions by DB2.

      A fixed point overflow can occur during any arithmetic operation on either INTEGER or SMALLINT fields.

      A decimal overflow exception can occur when one or more nonzero digits are lost because the destination field in any decimal operation is too short to contain the result.

      A divide exception can occur on a decimal division operation when the quotient exceeds the specified data-field size. A zero divide exception occurs on any division by zero.

      An exponent overflow can occur when the result characteristic of any floating-point operation exceeds 127 and the result fraction is not zero, i.e. the magnitude of the result exceeds approximately 7.2E+75.

      Any of the exceptions/overflows can occur during the processing of a built-in function.
      If the operation-type is FUNCTION then the error occurred while processing either an input, intermediate, or final value. The cause could be that the value of a parameter is out of range.

      Note: Parts of exception-type, data-type, operation-type , and position-number may or may not be returned in SQLCA, depending upon when the error was detected.
  • Ação do sistema
    • For each expression in error the indicator variable is set to negative two (-2) to indicate a null value returned.
      The data variable is unchanged. Execution of the statement continues with all nonerror columns and expressions of the outer SELECT list being returned.
      If the statement is cursor controlled then the CURSOR will remain open.
  • Resposta ao Desenvolvedor
    • Examine the expression for which the warning occurred to see if the cause (or the likely cause) of the problem can be determined.
      The problem may be data-dependent, in which case it will be necessary to examine the data that was being processed at the time the error occurred.

      See the explanation of SQLCODE -405 for allowed ranges of numeric data types.

      SQLSTATE: 01519