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>
Organization: http://groups.google.com
Subject:      JDBC call vs. ODBC
Comments: To: sas-l@uga.edu
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:

PROC SQL;
connect to ODBC as DRV1 (dsn=MYDW);
Create table X as
select * from connection to DRV1 (
select distinct
   custact    as account
   from         dir.tablename
   where       rate = 'A'
  with UR)
  order by custact;
disconnect from DRV1;


Thanks to anyone who can advise me.