Re: Clause not correct for procedure or function.

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Thanks Chris...I appreciate the info. I played around with Navigator and
also created the procedure. I specified things like SPECIFIC (and other
keywords), and while it threw some errors, it created the procedure. I'm
feeling my way through this, but I'm thinking that creating procedures (and
functions and UDFs and such) may be easier done in Navigator rather than
STRSQL.


On Thu, Dec 27, 2012 at 5:58 PM, Hiebert, Chris <
chris.hiebert@xxxxxxxxxxxxxx> wrote:

> SPECIFIC NEWSYS/MSPSRVPGM(MSP_VALIDATESTORE)
>
> This is the part that is invalid.
>
> If you are overloading the procedure with multiple definitions you would
> provide a unique specific name to each procedure. Otherwise you can use
> the same name as the procedure itself.
>
> SPECIFIC NEWSYS/ MSP_VALIDATESTORE
>
> Here an excerpt from the v7r1 SQL Reference concerning Specific names.
>
> 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.
>
>
> Chris Hiebert
> Programmer/Analyst
> Disclaimer: Any views or opinions presented are solely those of the
> author and do not necessarily represent those of the company.
> --
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.