RE: [sqr-users] RE: Access Data through SQR present inadifferentinstance

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

OK, let me learn something here.  There are database links, of course, but
they are not part of the SQR language, and Balaji's organization ruled them
out.  ODBC can do it, but does that require a non-Oracle version of SQR?  My
reading of the connect command is that it allows you to log into the same
database as a different user, but maybe I've missed something.

-----Original Message-----
From: Elvis Pressly [mailto:elvisdman@hotmail.com] 
Sent: Monday, May 15, 2006 12:51 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] RE: Access Data through SQR present
inadifferentinstance

Yes you can do multiple connection if you have the proper ODBC setup. I have

done connecting
to oracle, DB2, Tandem and sybase at the same  sqr without any problem.


>From: "Knapp, Richard" <KnappR@umsystem.edu>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] RE: Access Data through SQR present in 
>adifferentinstance
>Date: Mon, 15 May 2006 13:26:55 -0500
>
>
>Sorry to contradict, Steven, but this is not true.
>
>There is the connect command, the are database links and, if the
>databases suppport ODBC, there is the -db switch on the begin-select
>commend.
>
>Richard Knapp
>AITS - Reporting
>University of Missouri
>Locust Street Building
>Columbia, MO 65201
>573-882-8856
>knappr@umsystem.edu
>
>
>-----Original Message-----
>From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
>[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
>Alexander, Steven
>Sent: Monday, May 15, 2006 12:00 PM
>To: 'This list is for discussion about the SQR database
>reportinglanguagefrom Hyperion Solutions.'
>Subject: RE: [sqr-users] RE: Access Data through SQR present in a
>differentinstance
>
>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
>
>_______________________________________________
>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