The following SQL error codes have been added in support of procedures and triggers:
Reason:
A user-written procedure has returned an SQLCODE that is not a valid DATACOM SQLCODE.
The SQLSTATE that equates to this SQL return code is 39001.
Action:
Modify, repreprocess, and recompile the procedure to follow all instructions given in Parameter Styles and Error Handling.
Reason:
There has been a procedure preparation error. The information in msg-string varies depending upon the error that has occurred.
The SQLSTATE that equates to this SQL return code is 38S01.
Action:
Correct the problem described by the msg-string.
Reason:
There has been a procedure execution error. The information in msg-string varies depending upon the error that has occurred. This message commonly occurs when you have not concatenated the load library (into which your procedure has been linked) into the STEPLIB of the DBMUFPR of your Multi-User Facility job. This is especially likely to be the cause of the message if the message resembles the following:
PROC authid.sql-proc-name: external-proc-name FETCH ERROR
For example, PROC SYSUSR.MYPROC: MYPROC FETCH ERROR.
The SQLSTATE that equates to this SQL return code is 38S02.
Action:
Correct the problem described by the msg-string.
Reason:
There has been a trigger preparation error. The information in msg-string varies depending upon the error that has occurred.
The SQLSTATE that equates to this SQL return code is 09S02.
Action:
Correct the problem described by the msg-string.
Reason:
There has been a trigger execution error. The information in msg-string varies depending upon the error that has occurred. This message commonly occurs when you have not concatenated the load library (into which your procedure has been linked) into the STEPLIB of the DBMUFPR of your Multi-User Facility job. This is especially likely to be the cause of the message if the message resembles the following:
TRIG authid.sql-trig-name: external-proc-name FETCH ERROR
For example, TRIG SYSUSR.MYTRIG: MYPROC FETCH ERROR.
The SQLSTATE that equates to this SQL return code is 09S01.
Action:
Correct the problem described by the msg-string.
Reason:
There has been a user-defined procedure execution error. This SQL error code only occurs in procedures whose parameter style is SQL or DATACOM SQL. The information in the msg-string varies depending upon the error that has occurred, that is to say, user-written procedure logic creates the entire error message. The message is truncated if it exceeds the 80-byte length of the SQLCA error message area.
The SQLSTATE that equates to this SQL return code is 2FS04
Action:
Correct the problem described by the msg-string.
Reason:
There has been an environmental problem, possibly LE-related, that prevented the procedure from running. In the message, authid.name identifies the PROC and msg-string specifies the cause.
The SQLSTATE that equates to this SQL return code is 39S01.
Action:
Correct the problem described by the msg-string.
Reason:
There has been a user-defined execution error in an SQL procedure (a "LANGUAGE SQL" procedure). The information in the msg-string varies, depending upon the error that has occurred, that is to say, user-written procedure logic creates the entire error message. The message is truncated if it exceeds the 80-byte length of the SQLCA error message area.
The SQLSTATE that equates to this SQL return code is 38S04.
Action:
Correct the problem described by the msg-string.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|