Re: Accessing multiple databases

[DaveL Smith <davesmit@US.IBM.COM>]

Jeffrey,

I am doing a transfer from SQL Server 6.5 to SQL Server 7, its possible as long
as the machine you are running on has connectivity through ODBC to all of the
platforms.

What I do is specify the DSN connectivity on my BEGIN-SELECT statements.  I
select from one interface table into variables, then call a procedure that
connects to the other database and inserts the variables into the interface
table of the target.

David L. Smith
IBM Global Services




"Jeffrey K. Bedell" <jkbedell@AIS.SYR.EDU> on 10/07/99 10:34:13 AM

Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:
Subject:  Accessing multiple databases




Greetings fellow SQR users -
    I have been monitoring this list serv for many months now and have
picked up many useful tidbits of information but never found the need to
make use of it.  Until now.  We are a university and therefore have
multiple platforms and environments scattered all over the place.  To
transfer information between systems we generally run an SQR that
extracts the data from one database, FTP the file over to another server
and then run another SQR which updates the second database.  What I was
wondering is, is it possible to access two separate database in the same
SQR?  That is, can I read from one database (SYBASE) and insert into a
second database (ORACLE) within the same SQR?  Anybody ever done this or
even know if it is possible?
    Thanks for any input you can offer.

- Jeff Bedell - Syracuse University

jkbedell.vcf