Stored Procedures

Ian Dauncey

Stored Procedures
Hi All,

I need to move our Stored procedures from the pre-production box to the
production box.
What is the best way to do this without having the Stored procedure building
loaded on the production machine.

Both boxes are AIX with DB2UDB v7.2 loaded.

Any help would be appreciated.

Regards
Ian

___________________________________________________________________________________________________


The views expressed in this email are, unless otherwise stated, those of the author and not those
of the FirstRand Banking Group or its management. The information in this e-mail is confidential
and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying, distribution or any action taken or
omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data
transmitted electronically and to preserve the confidentiality thereof, no liability or
responsibility whatsoever is accepted if information or data is, for whatever reason, corrupted
or does not reach its intended destination.

________________________________



Swaminaathan K.R

Re: Stored Procedures
(in response to Ian Dauncey)
You can use GET ROUTINE and PUT ROUTINE for stored proc migration. This does not need recompilation of the SP in production.

-----Original Message-----
From: Dauncey, Ian [mailto:[login to unmask email]
Sent: Monday, January 13, 2003 2:34 PM
To: [login to unmask email]
Subject: Stored Procedures

Hi All,

I need to move our Stored procedures from the pre-production box to the
production box.
What is the best way to do this without having the Stored procedure building
loaded on the production machine.

Both boxes are AIX with DB2UDB v7.2 loaded.

Any help would be appreciated.

Regards
Ian

___________________________________________________________________________________________________


The views expressed in this email are, unless otherwise stated, those of the author and not those
of the FirstRand Banking Group or its management. The information in this e-mail is confidential
and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying, distribution or any action taken or
omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data
transmitted electronically and to preserve the confidentiality thereof, no liability or
responsibility whatsoever is accepted if information or data is, for whatever reason, corrupted
or does not reach its intended destination.

________________________________