Date:         Mon, 13 Dec 2004 14:55:17 -0500
Reply-To:     "Chaudhury, Jayati [IT]" <jayati.chaudhury@CITIGROUP.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Chaudhury, Jayati [IT]" <jayati.chaudhury@CITIGROUP.COM>
Subject:      use pass through SQL to insert into Oracle table
Content-Type: text/plain; charset="iso-8859-1"

Hi SAS experts,

I am currently using the following code to insert data into an Oracle table:

proc sql noprint;
   insert into dblib.job_status
    select * from work.job_status;
quit;
run;

The dataset work.job_status has all columns of the table job_status. The columns are:

SQL>desc JOB_STATUS;

JOB_STATUS_ID
JOB_ID
PHASE_ID
PHASE_STATUS_ID
RUN_SEQ
PID
START_TIME
END_TIME
USER_STAMP
TIME_STAMP


This works. However the performance is not good (takes 30secs to insert 1 record) and keeps deteriorating as the table size grows.

I want to try the pass-through type of SQL insert to see if that makes a difference. I don't know the syntax of the pass-thru for insert. Any help would be appreciated.

Thks
Jayati