SQL Codes › SQL Return Codes -1 through -999 › -531 - PROC authid.name: msg-string

-531 - PROC authid.name: msg-string

Explanation

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.

User Response

Correct the problem described by the msg-string.