The DBLOAD Procedure for Relational Databases

LOAD Statement

Creates and loads the new DBMS table

Valid:

in the DBLOAD procedure (required statement for loading or appending data)

LOAD;

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.

Example

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;

Top of Page