Do you mean the specificname of the sql sp? If so, just use the
"SPECIFIC <specific-name>" option on the create procedure statement.
From the SQL ref:
"SPECIFIC specific-name
Provides a unique name for the instance of the procedure that is
being defined. This specific name can be used when dropping the
procedure or commenting on the procedure. It can never be used to invoke
the procedure. The unqualified form of specific-name is an SQL
identifier (with a maximum length of 18). The qualified form is a
schema-name followed by a period and an SQL identifier. The name,
including the implicit or explicit qualifier, must not identify another
routine instance that exists at the application server; otherwise an
error (SQLSTATE 42710) is raised.
The specific-name may be the same as an existing procedure-name.
If no qualifier is specified, the qualifier that was used for
procedure-name is used. If a qualifier is specified, it must be the same
as the explicit or implicit qualifier of procedure-name or an error
(SQLSTATE 42882) is raised.
If specific-name is not specified, a unique name is generated by
the database manager. The unique name is SQL followed by a character
timestamp, SQLyymmddhhmmsshhn."
Hype wrote:
Hi,
How can we specify the package names for sql stored procedures instead
of system generated names ?
(Db2 V8.2 on Windows.)
thanks.....