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


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

   
 
  • Causa
    • A ROWSET FETCH STATEMENT MAY HAVE RETURNED ONE OR MORE ROWS OF DATA.
      HOWEVER, ONE OR MORE NON-TERMINATING ERROR CONDITIONS WERE ENCOUNTERED.
      USE THE GET DIAGNOSTICS STATEMENT FOR MORE INFORMATION REGARDING THE CONDITIONS THAT WERE ENCOUNTERED.

      A rowset FETCH statement encountered one or more non-terminating error conditions.
      One or more warnings might also have been encountered.
      Use the GET DIAGNOSTICS statement to obtain information about the conditions that occurred, and to determine if data was returned.
      It is possible that one or more rows of data were returned.
      In cases where the row information returned for the row that encountered the condition is incomplete, use of the data for the row that encountered the condition, such as displaying or printing the data, is not recommended.
  • Ação do sistema
    • Db2 processed the statement successfully, but with at least one non-terminating error.
      Additionally, the fetching of some rows might have encountered warnings.
  • Resposta ao Desenvolvedor
    • Analyze the conditions to determine whether follow-up actions are needed.
      The GET DIAGNOSTICS statement can be used to determine which additional actions might be necessary.

      Attention: It is possible that an end of data condition was detected.
      SQLERRD3 and GET DIAGNOSTICS can be used to determine if all the requested rows were fetched or if a partial rowset was returned.

      SQLSTATE: 22537

© Copyright IBM Corp.