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

["Jamie Harris" <JHarris@frederick.edu>]

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