RE: [sqr-users] Joining 2 data sources (local results)

[Courtney Nelson <can76db@yahoo.com>]

Richard - thanks for your reply.  
   
  I do have ODBC version of SQR - right now I simply need a sample of what the 
connect code would look like.  
   
  I have tried several ones but I am not having any luck.
   
  Thanks again
  Courtney

"Knapp, Richard" <KnappR@umsystem.edu> wrote:
  
Courtney,

SQR connects to one database at a time. Oracle supports database links
which let you refer to a remote database. Here the database provides a
connection to the remote database, not SQR. I don't know if Terradata or
DB2 have equivalent functions. Since they are different databases,
maybe you could exploit ODBC but for this you would need the ODBC
version of SQR.

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
Courtney Nelson
Sent: Wednesday, August 09, 2006 3:06 PM
To: Steven.Alexander@sanjoseca.gov
Cc: sqr-users@sqrug.org
Subject: RE: [sqr-users] Joining 2 data sources (local results)

I mean 2 databases. I understand that in SQR you are working within one
connection. But I would like to know if you can have 2 connections
within the same SQR document. 

One connects to Teradata and the other connects to DB2. Is this
possible to have in the same document? If so, can you provide me the
code that adds the other connection within the document? (I am not using
the developer wizard)

Ultimately, I am wanting to take the Teradata results and the DB2
results and merge them into 1 final result set. I honestly don't know
if this is possible, I have heard mixed answers on this. 

Any info would be great.

Thanks for your reply!

CNelson

"Alexander, Steven" wrote:
Do you mean two tables within a single database, or two databases, or
a
database and something else (like a spreadsheet)?

-----Original Message-----
From: Courtney Nelson [mailto:can76db@yahoo.com] 
Sent: Wednesday, August 09, 2006 11:21 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Joining 2 data sources (local results)


I am very new to SQR, I am a Hyperion (Brio) user. 

Does anyone have a sample of how to take 2 data sources and then join
them
together almost like Brio joining Local Results? 
I have asked around and no one can tell me that it can be done. Can this
be done? 

If so, any kind of sample would be helpful.


Thank You
CNelson


---------------------------------
Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail Beta.

_______________________________________________
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



---------------------------------
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.

_______________________________________________
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


                
---------------------------------
Do you Yahoo!?
 Next-gen email? Have it all with the  all-new Yahoo! Mail Beta.

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