Aviso importante


  C. A. Dornelles

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


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 +464

   
 
  • Causa
    • PROCEDURE proc RETURNED num QUERY RESULT SETS, WHICH EXCEEDS THE DEFINED LIMIT integer

      The stored procedure named by proc completed normally.
      However, the stored procedure exceeded the defined limit on the number of query result sets the procedure can return.
      • num identifies the number of query result sets returned by the stored procedure.
      • integer identifies the defined limit on the number of query result sets for the stored procedure.
      Only the first integer query result sets are returned to the SQL program that issued the SQL CALL statement.

      The possible causes are as follows:
      • The stored procedure is unable to return num result sets due to the limit defined for the procedure.
      • The stored procedure is unable to return num result sets due to the DRDA limitations imposed by the client.
        The DRDA client establishes this limit with the MAXRSLCNT DDM code point.
  • Ação do sistema
    • The SQL statement is successful.
      The SQLWARN9 field is set to 'Z'.

      SQLSTATE: 0100E