The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 Load and Oracle SQL*Loader

A technical overview

Return to article

Listing 2. The syntax of the DB2 LOAD command


.-,--------------.                 
V                |                 
>>-LOAD--+--------+--FROM----+-filename---+-+--OF--filetype----->
'-CLIENT-'          +-pipename---+                   
+-device-----+                   
'-cursorname-'                   
        
>--+-------------------------+--+------------------------+------>
|            .-,--------. |  |           .-,--------. |   
|            V          | |  |           V          | |   
'-LOBS FROM----lob-path-+-'  '-XML FROM----xml-path-+-'   
        
>--+--------------------------------+--------------------------->
|              .---------------. |   
|              V               | |   
'-MODIFIED BY----file-type-mod-+-'   
        
>--+-------------------------------------------------------------------------------+-->
|                 .-,------------------------.                                      |
|                 V                          |                                      |
'-METHOD--+-L--(----column-start--column-end-+--)--+-------------------------------+-+-'
|                                 |                     .-,-------------------.   | |
|                                 |                     V                     |   | |
|                                 '-NULL INDICATORS--(----null-indicator-list-+--)-'|
|       .-,-----------.                                                             |
|       V             |                                                             |
+-N--(----column-name-+--)----------------------------------------------------------+
|       .-,---------------.                                                         |
|       V                 |                                                         |
'-P--(----column-position-+--)------------------------------------------------------'
        
>--+------------------------------------+----------------------->
'-XMLPARSE--+-STRIP----+--WHITESPACE-'   
'-PRESERVE-'                 
        
>--+--------------------------------------------------------------------------+-->
'-XMLVALIDATE USING--+-XDS--+-----------------------+--| Ignore and Map parameters |-+-'
|      '-DEFAULT--schema-sqlid-'                                |
+-SCHEMA--schema-sqlid------------------------------------------+
'-SCHEMALOCATION HINTS------------------------------------------'
        
>--+--------------+--+-------------+--+-----------------+------->
'-SAVECOUNT--n-'  '-ROWCOUNT--n-'  '-WARNINGCOUNT--n-'   
        
>--+------------------------+----------------------------------->
'-MESSAGES--message-file-'   
        
>--+-------------------------------+---------------------------->
'-TEMPFILES PATH--temp-pathname-'   
        
>--+-INSERT-----------------------+----------------------------->
|          .-KEEPDICTIONARY--. |   
+-REPLACE--+-----------------+-+   
|          '-RESETDICTIONARY-' |   
+-RESTART----------------------+   
'-TERMINATE--------------------'   
        
>--INTO--table-name--+-------------------------+---------------->
|    .-,-------------.    |   
|    V               |    |   
'-(----insert-column-+--)-'   
        
>--+----------------------------------------------------------+-->
|                            .-,-------------------------. |   
|                            V  (1)   (2)                | |   
'-FOR EXCEPTION--table-name--------------+-------------+-+-'   
+-NORANGEEXC--+       
'-NOUNIQUEEXC-'       
        
>--+-----------------------------+------------------------------>
'-STATISTICS--+-USE PROFILE-+-'   
'-NO----------'     
        
>--+-----------------------------------------------------------------+-->
|       .-NO----------------------------------------------------. |   
+-COPY--+-YES--+-USE TSM--+--------------------------+--------+-+-+   
|              |          '-OPEN--num-sess--SESSIONS-'        |   |   
|              |     .-,----------------.                     |   |   
|              |     V                  |                     |   |   
|              +-TO----device/directory-+---------------------+   |   
|              '-LOAD--lib-name--+--------------------------+-'   |   
|                                '-OPEN--num-sess--SESSIONS-'     |   
'-NONRECOVERABLE--------------------------------------------------'   
        
>--+-------------------+--+--------------------------+---------->
'-WITHOUT PROMPTING-'  '-DATA BUFFER--buffer-size-'   
        
>--+--------------------------+--+--------------------+--------->
'-SORT BUFFER--buffer-size-'  '-CPU_PARALLELISM--n-'   
        
>--+---------------------+--+----------------------------+------>
'-DISK_PARALLELISM--n-'  |                    .-YES-. |   
'-FETCH_PARALLELISM--+-NO--+-'   
        
>--+--------------------------------+--------------------------->
'-INDEXING MODE--+-AUTOSELECT--+-'   
+-REBUILD-----+     
+-INCREMENTAL-+     
'-DEFERRED----'     
        
.-ALLOW NO ACCESS-----------------------------.   
>--+---------------------------------------------+-------------->
'-ALLOW READ ACCESS--+----------------------+-'   
'-USE--tablespace-name-'     
        
>--+----------------------------------------------+------------->
'-SET INTEGRITY PENDING CASCADE--+-IMMEDIATE-+-'   
'-DEFERRED--'     
        
>--+-----------------+------------------------------------------>
'-LOCK WITH FORCE-'   
        
>--+----------------------------------------------------------------------------+-->
'-SOURCEUSEREXIT--executable--| Redirect Input/Output parameters |--+-------------+-'   
'-PARALLELIZE-'     
        
>--+------------------------------------------------------+----><
|                            .-----------------------. |   
| .-PARTITIONED DB CONFIG-.  V                       | |   
'-+-----------------------+----partitioned-db-option-+-'   
        
Ignore and Map parameters
        
|--+--------------------------------+--------------------------->
|            .-,------------.    |   
|            V              |    |   
'-IGNORE--(----schema-sqlid-+--)-'   
        
>--+----------------------------------------------------+-------|
|         .-,-----------------------------------.    |   
|         V                                     |    |   
'-MAP--(----(--schema-sqlid--,--schema-sqlid--)-+--)-'   
        
Redirect Input/Output parameters
        
|--+---------------------------------------------------------------------------------+--|
'-REDIRECT--+-INPUT FROM--+-BUFFER--input-buffer-+--+-----------------------------+-+-'   
|             '-FILE--input-file-----'  '-OUTPUT TO FILE--output-file-' |     
'-OUTPUT TO FILE--output-file-------------------------------------------'

Return to article

My developerWorks:

My notifications:

Select a language:

Technical topics

Evaluation software

Community

Events

DB2 Load and Oracle SQL*Loader

Share this page:

Follow developerWorks: