Previous Page | Next Page

The DBLOAD Procedure for Relational Databases

Example: Append a Data Set to a DBMS Table

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.


[continuerule]

EXAMPLE (no-title)

Previous Page | Next Page | Top of Page