Alias to a Stored Procedure (z/OS V11)

John Kliewe

Alias to a Stored Procedure (z/OS V11)

I have a stored proc called PROC5.  It is in a schema named SCHEMAX.  

I have a user connecting from a java program.  This user has a config files that sets the schema name to SCHEMAY.  I would like this user to run my stored proc5, but I don't want to tell him to use SCHEMAY for his queries but SCHEMAX for calls.

Is there a way to allow users to refer to my stored procedure as SCHEMAY.PROC5, and having it actually point to the stored proc I created in SCHEMAX?  If not, can someone think of a way to accomplish this without having to maintain two separate copies of my stored proc?

Jørn Thyssen

RE: Alias to a Stored Procedure (z/OS V11)
(in response to John Kliewe)

Hi John,

 

Have you tried currentFunctionPath=SCHEMAX ?


In Reply to John Kliewe:

I have a stored proc called PROC5.  It is in a schema named SCHEMAX.  

I have a user connecting from a java program.  This user has a config files that sets the schema name to SCHEMAY.  I would like this user to run my stored proc5, but I don't want to tell him to use SCHEMAY for his queries but SCHEMAX for calls.

Is there a way to allow users to refer to my stored procedure as SCHEMAY.PROC5, and having it actually point to the stored proc I created in SCHEMAX?  If not, can someone think of a way to accomplish this without having to maintain two separate copies of my stored proc?



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal. 

Michael Hannan

RE: Alias to a Stored Procedure (z/OS V11)
(in response to John Kliewe)

One Stored Proc can call another (with extra overhead). Maintaining two copies might be better.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd