Re: Problem creating a SQL Procedure.

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Message: [SQL0455] Schema LTL400SAI3 for specific name not same as routine
schema QGPL.

The specific name for a procedure: When defining multiple procedures with
the
same name and schema (with different number of parameters), it is
recommended
that a specific name also be specified. The specific name can be used to
uniquely
identify the procedure when dropping, granting to, revoking from, or
commenting
on the procedure.
If specific-name is not specified, it is the same as the procedure name. If
a function
or procedure with that specific name already exists, a unique name is
generated
similar to the rules used to generate unique table names.

You can't have the procedure created in QGPL with a specific in another
schema...

Charles

On Wed, Oct 18, 2017 at 3:08 PM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

> 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 is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD