Date:         Tue, 10 May 2005 09:56:12 -0400
Reply-To:     "F. J. Kelley" <jkelley@UGA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "F. J. Kelley" <jkelley@UGA.EDU>
Subject:      Re: newbie DBLOAD to Oracle question
Comments: To: nevin.krishna@GMAIL.COM
Content-Type: text/plain; charset=us-ascii

Hi Nevin,
At SUGI29 Lois Levin covered a lot of this; see
  http://www2.sas.com/proceedings/sugi29/106-29.pdf

there is a lot deal of _great_ db information in the SUGI (as
well as the Regional UG) proceedings.  For SUGI, see:

http://support.sas.com/usergroups/sugi/proceedings/index.html

Information re Oracle is probably the most common, but DB2,
SQL Server and the others are there as well.

---- Original message ----
>Date: Tue, 10 May 2005 06:26:07 -0700
>From: nevin.krishna@GMAIL.COM
>Subject: newbie DBLOAD to Oracle question
>To: SAS-L@LISTSERV.UGA.EDU
>
>Hello all,
>
>I have been reading some of the past SAS-L posts regarding
updating
>oracle tables (from SAS data sets) using DBLOAD and am
confused about
>one simple question. Suppose you have a sas data set for
which you want
>to create a new oracle table..Can this be done without first
creating
>the table structure in ORACLE? or can sas simply output the
variables
>structure from sas to oracle automatically? I hope this is
clearly
>written enough to understand what i am getting at..Please
let me know
>if further clarification is needed...
>
>Thanks,
> Nevin
>Louisiana Office of Public Health