Re: Clause not correct for procedure or function.

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.