Loading the SQL/DS Tables

Figure 1 shows the statements required to load the Group Basic Data record. The RACDBULD SAMPLE file contains statements that load all the record types produced by the database unload utility. The sample requires that the output of RACFDBU be made into a fixed record length file.

Figure 1. SQL/DS Utility Statements Required to Load the Tables

DATALOAD TABLE (GROUP_BD)           IF POS(1:4)='0100'
          GPBD_NAME                  006-013
          GPBD_SUPGRP_ID             015-022
          GPBD_CREATE_DATE           024-033
          GPBD_OWNER_ID              035-042
          GPBD_UACC                  044-051
          GPBD_NOTERMUACC            053-053
          GPBD_INSTALL_DATA          058-311
          GPBD_MODEL                 314-357
          INFILE(IRRDBU00)
          )

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