RE: [sqr-users] Selecting from one database andupdating/inserting in another.

["Knapp, Richard" <KnappR@umsystem.edu>]

Or you can "connect" to the remote db from within the SQR environment.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: Jamie Harris [mailto:JHarris@frederick.edu]
Sent: Tuesday, April 22, 2003 2:09 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Selecting from one database
andupdating/inserting in another.


You can do this without a database link too, using the -DB option.


You could run you begin-select in one database, then on your begin-sql
line for the insert, add the -DB flag to make the insert happen in the
other database.


Here is the syntax (this was pasted from the SQR Command Help reference
under "begin-sql"):


-DBdatabase 
        (SQLBase) Specifies the default database name for this SQL
paragraph only.
-DBconnectionstring 
        (ODBC) Specifies the ODBC connection string for this SQL
paragraph only. A connection string has the following syntax:

DSN=data_source_name[;keyword=value[;keyword=value
[;...]]]
        
        This option allows you to combine data from multiple databases
in one program. For example, a connection string for an Oracle named
"ora8" might look like the following:
        'DSN=ora8;UID=scott;PWD=tiger'  where DSN, UID, and PWD are
keywords common to all drivers (representing '. name, user ID, and
password, respectively). Connection string options are always separated
by a semicolon (;). Other driver-specific options may be added to the
connection string using driver-defined keywords. See your ODBC driver
documentation for available options.





-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> preetamk@hotmail.com 4/22/2003 2:31:14 PM >>>
Hi,

I need to select from one Oracle database (Peoplesoft) and
update/insert in 
another Oracle database. Could anybody help me with this?

Thanks,
Preetam

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users