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!
3  2865 
"Willis" <me**********@hotmail.com> wrote in message
news:be******************************@localhost.ta lkaboutdatabases.com... 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!
Have you had a look at http://www-106.ibm.com/developerwork...tml#scenario8?
This article doesn't address stored procedures but it might help you get
your connections working....
Rhino
"Willis" <me**********@hotmail.com> wrote in message news:<be******************************@localhost.t alkaboutdatabases.com>... 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!
The simplest way to do is to copy from Development Center.
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) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: June Moore |
last post by:
Hi all,
I have a stored procedure that return a resultset
e.g. stored proc: get_employee_details
select emp_id, emp_name, emp_salary, emp_position
from empoloyee
I would like to write...
|
by: Alex |
last post by:
I have a "source" table that is being populated by a DTS bulk import
of a text file. I need to scrub the source table after the import
step by running appropriate stored proc(s) to copy the source...
|
by: xAvailx |
last post by:
I have a requirement that requires detection of rows deleted/updated by
other processes. My business objects call stored procedures to create,
read, update, delete data in a SQL Server 2000 data...
|
by: John |
last post by:
Hi
When developing vb.bet winform apps bound to sql server datasource, is it
preferable to use SELECTs or stored procedure to read and write data from/to
SQL Server? Why?
Thanks
Regards
|
by: mandible |
last post by:
I'm trying to call one stored procedure inside another.
I was wondering if this is possible
Some ideas I was toying with is putting the first stored procedure
inside of a temp table but haven't...
|
by: balaji krishna |
last post by:
Hi, I need to handle the return set from COBOL stored procedure from my invoking Java program. I do not know, how many rows the stored proc SQL fetches.I have declared the cursor in that proc, but i...
|
by: satkins |
last post by:
Hello everyone. I've been trying to find if this is even possible but nothing I've found has really helped.
I've got a stored proc with a few input parameters and one output parameter. I would...
|
by: Tim Zych |
last post by:
' Declare a new parameter object
Dim param() As SqlParameter = New SqlParameter(0) {}
' Set this to null and make it an InputOutput parameter
param(0) = New SqlParameter("@Something, DBNull.Value)...
|
by: brutusram |
last post by:
I am trying to execute SP that has another SP in it that is being passed multiple values. I want to stay away from cursors but I cannot find another way to do this in 2005.
BEGIN 1st STORED PROC...
|
by: mirandacascade |
last post by:
Questions toward the bottom of the post.
Situation is this:
1) Access 97
2) SQL Server 2000
3) The Access app:
a) sets up pass-thru query
b) .SQL property of querydef is a string, the...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| | |
