Date:         Mon, 1 Mar 1999 16:37:15 -0500
Reply-To:     murphym2@NATIONWIDE.COM
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Mike Murphy <murphym2@NATIONWIDE.COM>
Subject:      Re: Program to convert a SAS dataset to an Oracle Table
Comments: cc: "*Hou, John" <jhou@DEKALB.COM>
Content-Type: text/plain; charset=us-ascii

This works for me.
 
I am running on the UNIX platform when I submit this program.
 
Note that the path is the Oracle database.  It needs an "@" in front of the
database name.
 
 /****************************************************************/
 /*     S A S   D A T A   W A R E H O U S E   L I B R A R Y      */
 /*                                                              */
 /*  AUTHOR: MICHAEL F. MURPHY, NATIONWIDE INS.                  */
 /*    NAME: DBLOAD2.SAS                                         */
 /*    DESC: Program to convert a SAS dataset to an Oracle Table.*/
 /*  SYSTEM: UNIX                                                */
 /*    DATE: 12/1/1997                   UPDATE: 8/05/1998       */
 /*   NOTES:                                                     */
 /*                                                              */
 /****************************************************************/
 
proc dbload dbms=oracle data=sasuser.temp2;
 
 table=RAPP_Data;
  user=murphym2;
  orapw=password;
  path="@ver0";
  tablespace=users;
  reset all;
  label;
  limit=0;
  run;
 
 
 
 
 
 
"*Hou, John" <jhou@DEKALB.COM> on 03/01/99 11:48:36 AM
 
Please respond to "*Hou, John" <jhou@DEKALB.COM>
 
Sent by:  "*Hou, John" <jhou@DEKALB.COM>
 
To:   SAS-L@UGA.CC.UGA.EDU
cc:   (bcc: Michael F Murphy/Nationwide/NWIE)
Subject:  UPLOAD SAS DATA INTO ORACLE DATABASE USING PROC DBLOAD
 
 
 
 
Hi, my SAS folks,
 
I am working an application that will need to eventually upload SAS date set
into an ORACLE database.
 
I tried to follow the instruction of the SAS DBLOAD procedure almost
exactly:
 
        PROC DBLOAD DBMS=ORACLE DATA=sas_dset APPEND;
          USER=scott; PASSWORD=tiger;
          SQL CREATE a_table;
          TABLE=a_table;
          LOAD;
        RUN;
 
Also tested some other ways but still did not have much of success. The log
always shows some kind of ERROR messages, i.e. ERROR:  Oracle SQL Error:
-942. Re: ORA-00942 table or view does not exist.
 
I would really appreciated it, if you could provide some clues / examples.
 
John.