I've got some sas code that hits an oracle db (version 9 I think) that's
running dog-slow w/libname access. I'm trying to see if I can speed it
up w/pass-through, but am having trouble getting the syntax right it
Can somebody tell me what's wrong w/the following please?
proc sql ;
connect to oracle as ora (path = my_database user = roy password =
create table gnu as
select * from connection to ora
from drgsum as d
where d.AdmitDt between to_date('01-jan-2003') AND
d.obflag = '2'
That gives me the subject error. At first I thought I needed a
semicolon on the end of the passed-through statement, but if I do that I
get a 'ERROR 79-322: Expecting a ).' And I *can* do a 'select * from
dual' w/out the inner semicolon, so I think that bit is okay.
Can anybody throw me a clue here?