Re: Clause not correct for procedure or function.

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.