Willis wrote:
I have a db on one machine, and another on a second machine. I have written
some stored procedures that I want to copy to the second machine.
As I understand it, there is a possibility to connect the Development
Center to more than one db but, no matter how I try, I cant set up this
connection. One time I even managed to move the db on the second machine,
while I was trying to make a connection (from machine one...), and after
that it was impossible to access anything...
Is there anybody out there that has a perfectly simple example on how to
do this? With explanations what to fill in, in all fields, during the
process...
Or, if someone has a better way of getting the SP's over to the second
db...
Btw, I run in WinXp environment...
Many thanx in advance!
Bearing in mind that it's a good idea to be at the same release level
and on the same OS for both DBs, you can use get routine and put routine
from the command-line. I had a lot of trouble getting the development
center to work, mainly because I had different user ids on the two
systems. So now I do it like:
on server where SP is compiled -
db2 get routine into 'myroutine.sar' from specific routine
routines.myroutine; -- you don't have to use specific
on server where you want to put SP -
db2 put routine from 'myroutine.sar' owner user; -- to account for
new user name for the owner
--
Rob Wilson
ro********@ameritech.net.invalid (remove the .invalid)