Date:         Wed, 2 Jan 2002 10:38:07 -0800
Reply-To:     Stephen Arthur <sarthur67@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Stephen Arthur <sarthur67@YAHOO.COM>
Subject:      SQL Procedure Pass-Through Facility
Content-Type: text/plain; charset=us-ascii

Hi,

V8.2 Windows NT

I have been experimenting with the SQL Pass-Through
Facility.

I have a question.

Given this SAS code, which works:

**************************;

proc sql noerrorstop;
     connect to oracle (
          user=&USERNAME
          password=&PASSWORD
          path=&PATH
          );
     create view sasuser.&view as
          select * from connection to oracle
          (
          /**** INSERT ORACLE SQL STATEMENTS HERE
****/
          );
     %PUT &SQLXMSG;
     disconnect from oracle;
quit;

*********************;

My question is, where the "INSERT ORACLE SQL
STATEMENTS HERE" comment is in the above SAS code,
instead of reading in ORACLE SQL statements (which I
do so by cut and pasting from the ORACLE SQL
inspector), I would like to be able to read the .sql
oracle file which oracle creates in the SAS code
directly.

Can this be done in SAS?
How do you do it?

Stephen

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com