[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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" <Steven.Alexander@sanjoseca.gov> 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