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


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

   
 
  • Causa
    • THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE NUMBER position-number BECAUSE NO INDICATOR VARIABLE IS SPECIFIED.

      A FETCH, SELECT, VALUES INTO, or SET assignment statement resulted in the retrieval of a null value to be inserted into the output host variable, designated by entry number 'position-number' of the output SQLDA, for which no indicator variable was provided.
      An indicator variable must be supplied if a column returns a null value.
  • Ação do sistema
    • The statement cannot be executed. No data was retrieved.
  • Resposta ao Desenvolvedor
    • Examine the definition of the table that is the object of the statement and correct the application program to provide indicator variables for all host variables into which null values can be retrieved.
      This includes host variables for columns which can contain null values and host variables which receive the results of column functions whose result table could be empty.

      SQLSTATE: 22002

© Copyright IBM Corp.