Looking at the documentation for CREATE ALIAS (
CREATE ALIAS - IBM DB2 9.7 for Linux, UNIX, and Windows), I read as the first sentence:
Quote:
|
The CREATE ALIAS statement defines an alias for a module, nickname, sequence, table, view, or another alias. Aliases are also known as synonyms.
|
I don't see stored procedures mentioned as a valid target for an alias. Hence, you can't create aliases for SPs. You could create a new stored procedure with the desired name and that new procedure just calls the other one.