DB2 Stored Procedure migrations (UDB UNIX)

Gary V (ING) Scarcella

DB2 Stored Procedure migrations (UDB UNIX)
I'd like to know how people are migrating DB2 Stored Procedures from their
development UDB UNIX environment to their production UDB UNIX environment.

Does the qualifier of the stored procedure change when you migrate?
Are the table names qualified in the SQL in the Stored Procedure? (and if
they are qualified do the qualifiers change during migration?)
Any migration differences if using SQL vs Java stored procedures?
Do you use DB2 Stored Procedure Builder for the migration or something else?

Thanks,
Gary.

Gary Scarcella
ING-AFS/IRM/DBA - TSB2
Internet address: [login to unmask email]



Michael Finnis

Re: DB2 Stored Procedure migrations (UDB UNIX)
(in response to Gary V (ING) Scarcella)
Hello Gary,

I am a Product Specialist for Princeton Softech. We have a tool, Relational
Tools for Servers and in particular the module Move for Servers, which will
migrate Stored Procedures between DBMS subsystems.

You may care to look at:
http://www.princetonsoftech.com/products
and look at "Move for Servers" in particular.

HTH,
Mike Finnis
Product Specialist
Princeton Softech Australia



-----Original Message-----
From: Scarcella, Gary V (ING) [mailto:[login to unmask email]
Sent: Tuesday, January 09, 2001 2:59 AM
To: [login to unmask email]
Subject: DB2 Stored Procedure migrations (UDB UNIX)


I'd like to know how people are migrating DB2 Stored Procedures from their
development UDB UNIX environment to their production UDB UNIX environment.

Does the qualifier of the stored procedure change when you migrate?
Are the table names qualified in the SQL in the Stored Procedure? (and if
they are qualified do the qualifiers change during migration?)
Any migration differences if using SQL vs Java stored procedures?
Do you use DB2 Stored Procedure Builder for the migration or something else?

Thanks,
Gary.

Gary Scarcella
ING-AFS/IRM/DBA - TSB2
Internet address: [login to unmask email]