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


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

   
 
  • Causa
    • A VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE NUMBER position-number BECAUSE THE DATA TYPES ARE NOT COMPARABLE.

      A CALL, FETCH, SELECT, VALUES INTO, or SET host-variable statement with an output host variable, whose entry in the output SQLDA is indicated by position-number, could not be performed.
      The data type of the variable was not compatible with the data type of the corresponding SELECT, VALUES INTO, or SET host-variable statement list element.
      The values of the output host variable and the corresponding list element must be in one of the following categories:
      • Both must be numbers.
      • Both must be character strings if not using Unicode.
      • Both must be graphic strings if not using Unicode.
      • Both must be row IDs.
      In addition, for datetime, timestamp values, the host variable must be a character string variable with a correct length.
  • Ação do sistema
    • The CALL, FETCH, SELECT, VALUES INTO, or SET host-variable statement cannot be executed. No data was retrieved.
  • Resposta ao Desenvolvedor
    • Verify that table definitions are current and that the host variable has the correct data type.

      SQLSTATE: 42806

© Copyright IBM Corp.