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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.