The DBLOAD Procedure for Relational Databases |
Creates and loads the new DBMS table
Valid: |
in the DBLOAD procedure (required statement for
loading or appending data)
|
The LOAD statement informs the DBLOAD procedure to execute
the action that you request, including loading or appending data. This statement
is required to create and load a new DBMS table or to append data to an existing
table.
When you create and load a DBMS table, you must place
statements or groups of statements in a certain order after the PROC DBLOAD
statement and its options, as listed in
Statement Sequence for Accomplishing Common Tasks with the DBLOAD Procedure.
This example creates the SummerTemps table in Oracle
based on the DLib.TempEmps data file.
proc dbload dbms=oracle data=dlib.tempemps;
user=testuser; password=testpass;
path='testpath';
table=summertemps;
rename firstnam=firstname
middlena=middlename;
type hiredate 'date'
empid 'number(6,0)'
familyid 'number(6,0)';
nulls 1=n;
list;
load;
run;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.