[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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


begin:vcard
n:Bedell;Jeffrey K.
tel;fax:(315) 443-3553
tel;work:(315) 443-9273
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:jkbedell@ais.syr.edu
x-mozilla-cpt:;31856
fn:Jeffrey K. Bedell
end:vcard