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

-530 - PROC authid.name: msg-string

Explanation

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.

User Response

Correct the problem described by the msg-string.

Note: During the preprocessing procedure, we create a plan to hold the statements related to each LANGUAGE SQL procedure. If a CREATE PROCEDURE embedded in a host language program (COBOL, PL/I, C, or Assembler) receives a -530 with a msg-string as follows: PLAN plan-name IN USE. RENAME PROCEDURE, the new procedure name is available in your system but there is a conflict with the plan name derived from your procedure name. If there is an unrelated application that uses this plan name, rename your procedure. Drop the plan if the plan was left over from a previous run of a precompile where the CREATE PROCEDURE failed to successfully execute (if the procedure had been created, you would have received a msg-string of: PROCEDURE NAME IN USE). One method for doing a DROP is to run DBSRFPR with the following command: DROP PLAN=auth-id.plan-name.