Geschrieben von Bernd Heilig on November 28, 2002 um 16:10:

Als Antwort auf FEHLERMELDUNG STORED PROCEDURE BUILDER geschrieben von Christian Wehle on November 28, 2002 um 15:25:

Hallo Christian,

ich denke dass hier einiges nicht korrekt installiert ist. Der SQlcode -471 ist allerdings sehr allgemein gehalten, es kann so gut wie alles sein. Nähere Hinweise findset du im DB2 Master Log (MSTR Addressspace) auf der OS/390.

Hier eine Erklärung des Reason-Codes aus DB2 Mesage und Code Version 7

00E79106

Explanation: DB2 could not process an SQL CALL statement for a REXX stored procedure. There were errors associated in setting up an environment to run a REXX stored procedure. See the system console for the associated DSNX993I message.

System Action: The SQL statement fails with this reason code and SQL code -471.

Programmer Response: Use the information provided in the DSNX993I message, and the TSO and REXX messages in ddname SYSTSPRT for diagnosis.
You can find TSO and REXX message explanations in OS/390 TSO/E Messages | and OS/390 TSO/E REXX Reference.

Hier die Erklärung des SQLCODES -471

-471 INVOCATION OF FUNCTION OR PROCEDURE name FAILED DUE TO REASON rc

Explanation: A routine was invoked. The routine invocation was not accepted because of DB2 reason code rc.

name
The name of the routine that was invoked.

rc
The DB2 reason code describing the cause of the failure.

System Action: The statement cannot be executed. A DSNX9xx message describing the error might be displayed on the MVS system console.
Programmer Response: Correct the condition described by the DB2 reason code.

viel Glück
Bernd

• Re: FEHLERMELDUNG STORED PROCEDURE BUILDER Christian Wehle 16:24 05.12.2002 (0)

Schreibe eine Antwort