SQL - SQLCODE's - Códigos negativos -310


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 -310

   
 
  • Causa
    • DECIMAL HOST VARIABLE OR PARAMETER number CONTAINS NON-DECIMAL DATA.

      DB2 received nondecimal data from either an application (in the form of a host variable), function or a stored procedure (in the form of a parameter that was passed to or from function or a stored procedure).
      number
      Identifies either the host variable number (if the message is issued as a result of a FETCH, INSERT, UPDATE, DELETE, SELECT, VALUES INTO, or SET assignment statement statement), or the parameter number (if the message is issued as the result of the invocation of a function, or a CALL statement).
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Correct the application program or stored procedure.
      Ensure that all decimal variables or parameters contain valid System/370 packed decimal numbers.

      SQLSTATE: 22023

© Copyright IBM Corp.