Re: Accessing multiple databases

["Salem, Mark" <msalem@MSA.COM>]

Do you have an example that you could share with us?  Thanks!

> -----Original Message-----
> From: DaveL Smith
> Sent: Thursday, October 07, 1999 10:25 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Accessing multiple databases
>
>
>
> 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
>
>  << File: jkbedell.vcf >>