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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved