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


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

   
 
  • Causa
    • A VALUE WITH DATA TYPE data-type1 CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE THE VALUE IS NOT WITHIN THE RANGE OF THE HOST VARIABLE IN POSITION position-number WITH DATA TYPE data-type2.

      A CALL, FETCH, SELECT, VALUES INTO, or SET assignment statement with a host variable list or structure in position number position-number failed because the host variable with data type data-type2 was not large enough to hold the retrieved value with data type data-type1.
  • Ação do sistema
    • The statement cannot be executed. No data was retrieved.
      If the statement was a FETCH, the cursor remains open.
  • Resposta ao Desenvolvedor
    • Verify that table definitions are current, and that the host variable has the correct data type.
      See the explanation for SQLCODE -405 for ranges of SQL data types.

      SQLSTATE: 22003

© Copyright IBM Corp.