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;
The dataset work.job_status has all columns of the table job_status. The columns are:
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.