Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.

SQLCode +464
PROCEDURE proc RETURNED num QUERY RESULT SETS, WHICH EXCEEDS THE DEFINED LIMIT integer

Causa
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