If you have a windows client (or an x-windows on unix) you can run the
development center, import
all the stored procs to a new project and then export all those stored
procs to one file. You can then
connect to another database and import that file into a project and build
them all. Kind of kludgy.






"Naveen Akarapu "
<db2udbdba-ezmlms
hield-x4523753.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
05/24/2005 09:24
AM Subject
Move all the stored procedures











I can move one stored procedure using GET ROUTINE and PUT ROUTINE. Is
there any tool or command (like db2move is for EXPORT) to move all the
stored procedures.

Both the databases are DB2 8.1 on AIX.

Thanks in advance


Disclaimer:

This e-mail, and any files transmitted with it are confidential to Marlabs
Inc. and intended solely for the use of the individual or entity to whom it
is addressed. If you are not the intended recipient you are notified that
disclosing, copying, distributing or taking any action in reliance on the
contents of this information is strictly prohibited.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page