RE: [sqr-users] RE: Access Data through SQR present in a differentinstance

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

A single SQR program cannot log onto two database instances or even switch
between them.  You need two programs.  The first to run on INST1 and output
data to a flat file.  The second to run on INST2 and read the flat file.

If you're using the Peoplesoft Process Scheduler, you can set up a "job"
that executes two SQR programs.  Other job schedulers probably have similar
capability.  You could use a Unix command file to run one SQR after the
other.  You could execute one SQR from the other using the "call system"
command.

-----Original Message-----
From: Vedagiri, Balaji (GE, Corporate, consultant)
[mailto:balaji.vedagiri@ge.com] 
Sent: Monday, May 15, 2006 7:48 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] RE: Access Data through SQR present in a
differentinstance

Hi All

Thank you for the response. Since its not possible to create DB links in our
environment due to security restrictions, Can you please give me a solution
like,

Login into instance 1 get data from Table and write to a flat file, switch
to instance 2 read the data from table and process with data available in
flat file. Something like switching between the instances dynamically during
run-time from the same SQR.

Sorry for my earlier query not being specific.

Thanks in Advance
Balaji


>  -----Original Message-----
> From:         Vedagiri, Balaji (GE, Corporate, consultant)  
> Sent: Monday, May 15, 2006 10:01 AM
> To:   sqr-users@sqrug.org
> Subject:      Access Data through SQR present in a different instance
> 
> Hi
> 
> I am executing my SQR from Instance 1 (INST1 - Oracle), during one of my
validation I need to fetch data from the same table present in a different
distance (INST2). Is it possible to access data from a different instance.
The environment I am working in is Oracle on Unix Box, here we have
different Unix boxes and is it possible to access data from a different
instance (Oracle) sitting on a different Unix Box.
> 
> Can anyone please help me on this issue.
> 
> Thanks in Advance
> Balaji
> 

_______________________________________________
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