The DBLOAD Procedure for Relational Databases |
The following example appends new employee data from the NewEmp
SAS data set to the Employees DBMS table. The COMMIT statement causes a DBMS
commit to be issued after every 100 rows are inserted. The ERRLIMIT statement
causes processing to stop after 10 errors occur.
proc dbload dbms=oracle data=newemp append;
user=testuser;
password=testpass;
path='myorapath';
table=employees;
commit=100;
errlimit=10;
load;
run;
By omitting the APPEND option from the DBLOAD statement,
you can use the PROC DBLOAD SQL statements to create a DBMS table and append
to it in the same PROC DBLOAD step.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.