Loading an SQL-Defined Database › Loading Procedures › Full Load Procedure

Full Load Procedure

Steps

Follow these steps to perform a full load of an SQL-defined database:

Example

This example loads, builds, and validates tables ASSIGNMENT, CONSULTANT, EXPERTISE, SKILL, and PROJECT. Each of these tables is independent of those in other areas of the EMPLOYEE database. By default, CA IDMS/DB sorts the input data before it loads the tables. Also by default, if it finds any errors during any phase of the load procedure, it stops.

To load each table, CA IDMS/DB applies selection criteria against each input record it reads. For example, the ASSIGNMENT table receives all input records where the value in position 210 of the input record equals '512'. Similarly, the EXPERTISE table receives all input records where the value in position 210 equals '320'.

load
  into demoproj.assignment
    where position 210 = '512'
    (emp_id position 1 smallint,
     proj_id position 3 char(4),
     start_date position 13 date,
     end_date position 23 char(8) null if '01-01-01')

  into demoproj.consultant
    where position 210 = '222'

  into demoproj.expertise
    where position 210 = '320'
    (emp_id position 1 smallint,
     skill_id position 3 smallint,
     skill_level position 5 char(2) null if '99',
     exp_date position 7 date)

   into demoproj.project
     where position 210 = '416'

   into demoproj.skill
     where position 210 = '445';