Date: Mon, 1 Sep 1997 18:30:27 GMT
Reply-To: Greg Bryant <gbryant@SLIPNET.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Greg Bryant <gbryant@SLIPNET.COM>
Organization: Slip.Net (http://www.slip.net)
Subject: Re: Views of Oracle
Jamie Christopher Michael Beu <email@example.com> wrote:
If you're accessing Oracle using SAS Views, there will be no
pass-through processing. Some of us wish that this was the case!!!
So, you're safe. This is a good question to put to SAS Technical
Support if you want a more complete explanation.
>I am concerned about the division of labor between Oracle and SAS.
>I have views of Oracle tables, and I need to do some joins and other SQL
>manipulations on the data. However, I need to make sure that SAS alone
>will do the join, and not Oracle. All I expect from Oracle is to just view
>the raw tables, and that's it. Any calculations, manipulations, queries,
>etc. done in the PROC SQL statements must be done using only SAS
>resources. (Oracle will be too busy doing other things.)
>How can I be assured that this will be the case?
>My concerns came about because I thought that I had heard, during the demo
>of SAS, that if PROC SQL is working on a SAS dataset, then SAS will run
>the query. However, if PROC SQL is working on a view of Oracle tables,
>then SAS will do a pass-through of the query to Oracle, and Oracle will
>have to do the actual work and then report the results back to SAS.
>Any and all information you can send my way would be most appreciated.
>Thank you and God bless.
>Jamie Beu (firstname.lastname@example.org) Univ. of Central Florida, Orlando, FL
> "He (Christ) is risen! Alleluia!" (numerous places in the Bible)
> "I'm back on my e-mail again. Praise be to God!"