DBLOAD Procedure

LOAD Statement

Creates and loads the new DBMS table

Restriction:

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

Syntax

Details

Example

Syntax

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 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;