320 LOAD Statement Appendix 2
LOAD Statement
Creates and loads the new DBMS table
Valid: in the DBLOAD procedure (required statement for loading or appending data)
LOAD;
Details
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 Table A2.1 on page 314 with the DBLOAD Procedure.
Example
The following 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;
NULLS Statement
Specifies whether DBMS columns accept null values
Default: Y
NULLS variable-identifier-1 =Y|N<…variable-identifier-n =Y|N>;
