Re: Connecting to remote d/base through SQR

[Bob Buford <bbuford@CCCI.ORG>]

Hi Paul,

Go to URL  http://www.sqrug.com/sqr-users/  and search archive volumes for 
keyword connect.  Several popular choices seem to be using ODBC or having your 
dba set up a listener to one of the databases.  Perhaps ODBC might be better so 
you can write in same process instance to several different databases.

Anyway, once you are setup and connect like that, just use your BEGIN-SELECT 
and BEGIN-SQL paragraphs to manipulate data as you would directly in SQL.

Someone else had suggested an approach of having two different .INI files with 
shortcuts to your desktop, which would enable you to SELECT your data in one 
session, perhaps writing it to a file, then launching an SQR session into the 
other database and using the data in the file to insert into that database.

HTH,
Bob


>>> Paul Schattling <P.Schattling@MAILBOX.GU.EDU.AU> 04/01/99 02:21AM >>>
Okay, I'm sorry if this appears very basic so please be understanding.
We have peoplesoft Assets but not their full Financials (don't ask!).
Through an SQR (launched via peoplesoft) we are able to select data from
the remote Finance database and insert into the P/soft Asset database.
We now need to insert data back to our finance system.
I can't write to a remote d/base so I want to logon to the finance database
and do my select and insert from there.
If anyone can make sense of my dribble, can you advise of the
commands/procedures to use in SQR to obtain this.

Thanks in Advance
Paul Schattling