I am trying to create procedure but the system rejects it. I cannot
identify the problem

Create procedure QGPL.IAR500
(IN USER_ID CHAR(10),
IN PDate_From CHAR(08),
IN PDate_To CHAR(08),
OUT Error_Code CHAR(02),
OUT PERRMSG CHAR(100) )

EXTERNAL NAME myLib.IAC500
LANGUAGE RPGLE
SPECIFIC IAR500
NOT DETERMINISTIC
CALLED ON NULL INPUT
MODIFIES SQL DATA
PARAMETER STYLE GENERAL WITH NULLS
DYNAMIC RESULT SETS 1
;

The error is:
SQL State: 42882
Vendor Code: -455
Message: [SQL0455] Schema LTL400SAI3 for specific name not same as routine
schema QGPL. Cause . . . . . : The specific name schema LTL400SAI3
specified on a CREATE PROCEDURE, DECLARE PROCEDURE, or CREATE FUNCTION
statement is not the same as schema QGPL for procedure or function IAR500.
Recovery . . . : Specify the same schema for the specific name as for
the procedure or function name.

Error may be staring me in the face....

Darryl Freinkel

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.