Loading the SQL/DS Tables

Figure 1 shows the statements required to load the JOBINIT record. The IRRADULD SAMPLE file contains statements that load all the record types produced by the RACF SMF data unload utility. The sample requires that the output of RACFADU be made into a fixed record length file.

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

 DATALOAD TABLE (JOBINIT)   IF POS(5-12)='JOBINIT '
   INIT_EVENT_TYPE     5-12
   INIT_EVENT_QUAL     14-21
   INIT_TIME_WRITTEN   23-30     NULL IF POS(23-30) ='        '
   INIT_DATE_WRITTEN   32-41     NULL IF POS(32-41) ='          '
   INIT_SYSTEM_SMFID   43-46
   ...
   INIT_UTK_USER_ID    718-725
   INIT_UTK_GRP_ID     727-734
   INIT_UTK_DFT_GRP    736-736
   INIT_UTK_DFT_SECL   741-741
   INIT_APPC_LINK      746-761
  INFILE(IRRADU00);

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