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 <jcb20544@pegasus.cc.ucf.edu> wrote:
 
Jamie,
 
     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.
 
good luck,
 
greg
 
 
 
 
>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 (jcb20544@pegasus.cc.ucf.edu) 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!"