Loading the DB2 tables

Figure 1 shows the statements that are required to load the Group Basic Data record. The RACDBULD member of SYS1.SAMPLIB contains statements that load all of the record types produced by the database unload utility.

Figure 1. DB2 utility statements required to load the tables

LOAD DATA                                                           
     INDDN  tablespacename                                 
     RESUME YES                                                     
     LOG    NO                                                      
     INTO   TABLE userid.GROUP_BD                          
     WHEN(1:4)='0100' (                                             
         GPBD_NAME            POSITION(006:013)  CHAR(8),           
         GPBD_SUPGRP_ID       POSITION(015:022)  CHAR(8)            
         GPBD_CREATE_DATE     POSITION(024:033)  DATE EXTERNAL(10), 
         GPBD_OWNER_ID        POSITION(035:042)  CHAR(8),           
         GPBD_UACC            POSITION(044:051)  CHAR(8),           
         GPBD_NOTERMUACC      POSITION(053:053)  CHAR(1),           
         GPBD_INSTALL_DATA    POSITION(058:311)  CHAR(254),         
         GPBD_MODEL           POSITION(314:357)  CHAR(44)           
         )

Note: You can choose not to load some of the tables.