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

["Elvis Pressly" <elvisdman@hotmail.com>]

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