Date: Tue, 14 Nov 2006 16:35:42 -0800
Reply-To: maryidahosas <maryidahosas@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: maryidahosas <maryidahosas@YAHOO.COM>
Subject: JDBC call vs. ODBC
Content-Type: text/plain; charset="iso-8859-1"
I typically run imbedded SQL in SAS with an ODBC call to a database.
My understanding is that JDBC calls are much more efficient at our
installation than ODBC. But, from the SAS documentation I couldn't
find much about JDBC calls. Can I do JDBC calls, and if so, how do I
do them? Would I just make sure the drivers are installed and replace
ODBC with JDBC in my code? The way I do my ODBC call is like this:
connect to ODBC as DRV1 (dsn=MYDW);
Create table X as
select * from connection to DRV1 (
custact as account
where rate = 'A'
order by custact;
disconnect from DRV1;
Thanks to anyone who can advise me.