Utility Statements › LOAD › Examples

Examples

Phased LOAD

The following sample statement instructs the LOAD utility to load data from an input file into various tables when a record in the input file at position 60 matches the where clause criteria.

load into load.a where position 60 = 'a'
     into load.b where position 60 = 'b'
     into load.h where position 60 = 'h'
no validate lrecl 80;

Complete LOAD

The next example instructs the LOAD utility to perform a complete load of data from an input file into various tables when a record in the input file at position 60 matches the where clause criteria. In addition, it will load data into two tables when a record in the input file matches the character string associated with the column name in the where clause.

load into load.c where position 60 = 'C'
     into load.d where position 60 = 'D'
     into load.e where position 60 = 'E'
     into load.f where position 60 = 'F'
     into load.g where position 60 = 'G'
     into load.m where mchar = 'm1'
   (mchar    position 1   char(2),
    mvchar   position 3   varchar,
    mbin     position 7   binary(2),
    mhalf    position 9   smallint,
    mfull    position 11  integer,
    mlong    position 15  longint,
    mdec     position 23  dec(2,1),
    mdecu    position 25  unsigned dec(3,3),
    mnum     position 27  num(2,1),
    mnumu    position 29  unsigned numeric(3,3),
    mdate    position 32  date,
    mtime    position 42  time,
    mts      position 50  timestamp)

     into load.m2 where position 1 = 'M2'
   (mgraph   position 3   graphic,
    mvgraph  position 5   vargraphic(4),
    mreal    position 15  real,
    mfloat1  position 19  float(4),
    mfloat2  position 23  float(50),
    mdp      position 31  double precision)
     errors continue
         lrecl 80;