Example 6 5   Simplified syntax of the DB2 LOAD command

>> LOAD  +        +  FROM    + filename   + +  OF  filetype     >

           CLIENT            + pipename   +

                             + device     +

                               cursorname  

>  +                               +                            >

   |              .              . |

   |              V              | |

     MODIFIED BY    filetype mod +  

>  +              +  +             +  +                 +       >

     SAVECOUNT  n      ROWCOUNT  n      WARNINGCOUNT  n  

>  +                        +                                   >

     MESSAGES  message file  

>  +                               +  + INSERT    +             >

     TEMPFILES PATH  temp pathname    + REPLACE   +

                                      + RESTART   +

                                        TERMINATE  

>  INTO  table name  +                         +                >

                     |    . ,             .    |

                     |    V               |    |

                       (    insert column +  )  

   . ALLOW NO ACCESS                             .

>  +                                             +              >

     ALLOW READ ACCESS  +                      +  

                          USE  tablespace name  

>  +                                      +                     >

     CHECK PENDING CASCADE  + IMMEDIATE +  

                              DEFERRED    

>  +                 +                                          >

     LOCK WITH FORCE  

For loading the application data into the DB2 UDB, MTK generates the following 

call of the 

LOAD

 command:

db2 LOAD from ""/.dat""

of DEL

modified by\

coldel0x09 

timestampformat=\"YYYY MM DD HH:MM:SS\" 

insert into .

DB2 IMPORT command

The 

IMPORT

 utility inserts data from an input file into a table or updateable view. If 

the table or view receiving the imported data already contains data, you can 

either replace or append to the existing data.

 Chapter 6. Data porting 

133