SQL - SQLCODE's - Códigos positivos - +904


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 +904
   
 
  • Causa
    • A RESOURCE IS UNAVAILABLE BUT PROCESSING CONTINUES. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name

      A resource was unavailable, but the processing of the SQL statement continues.

      reason-code
      The Db2® reason code value that indicates the reason for the failure.
      For explanations of reason codes, see Db2reason codes.
      resource-type
      The type of resource that the message identifies.
      For explanations of resource types, see Resource types.
      resource-name
      The name of the resource that the message identifies.

      The value in resource-name depends on the remote server source of SQLCODE +904.
      See the following notes for more information.

      Notes:

      • SQLCODE +904 is not issued by Db2 for z/OS®.
      • When reason-code is 00E7000E and resource-type is 00001080, SQLCODE +904 was issued by IBM Db2 Analytics Accelerator for z/OS, and resource-name is message text from the accelerator that indicates the reason for the SQL code.

        IBM Db2 Analytics Accelerator for z/OS can return SQLCODE +904 on an SQL OPEN for certain accelerated queries when the CURRENT QUERY ACCELERATION WAITFORDATA special register is used to specify a delay wait time for the query.
        See the IBM Db2 Analytics Accelerator for z/OS documentation for information about when SQLCODE +904 is returned for an accelerated query.

  • Ação do sistema
    • Processing of the SQL statement continues.
      When SQLCODE +904 is issued by IBM Db2 Analytics Accelerator for z/OS, processing of the SQL statement continues on the accelerator.
  • Resposta ao Desenvolvedor
    • No programmer response is needed.
      See the IBM Db2 Analytics Accelerator for z/OS documentation for more information about the situations that can result in SQLCODE +904 being issued.

      SQLSTATE: 01687