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

[Courtney Nelson <can76db@yahoo.com>]

You helped a lot.  I got it working in Teradata.  
   
  Thanks so much!

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

I think whatever method works, you will have to store the data from one
db in a data structure then combine/merge it with the other db's data.

The only SQR command that approaches what you want to do is the connect
command. I believe I have used it this way: 1. start your SQR logging
into the db that makes the most sense as the first db. 2. get the data
you need into a file or an array. 3. use the connect command to log into
the other db. The connect command wants to assume that you are logging
into the same db as a different user but you can fool it if the remote
db supports the database name as part of the username/password sequence.
In the oracle world that would look like: connect
'user/password@remote_db'.

If this won't work, get the data you need from the first db into a flat
file with one program then call another to connect to your second db,
read that flat file and process accordingly.

You may have to chain several programs and flat files.

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: Thursday, August 10, 2006 3:48 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.; Steven.Alexander@sanjoseca.gov
Subject: RE: [sqr-users] Joining 2 data sources (local results)

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" 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

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


                
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ 
countries) for 2¢/min or less.

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