-- ------------------------------------------------------------------- LOADING OF DATA: load_distr
--                                                                                   1999.04.22 ft
--
update LOAD_DISTR set data_size              = 0            where data_size               is NULL;
update LOAD_DISTR set access_acronym         ='*not filled' where access_acronym          is NULL;
update LOAD_DISTR set format_acronym         ='*not filled' where format_acronym          is NULL;
update LOAD_DISTR set fees_acronym           ='*not filled' where fees_acronym            is NULL;
update LOAD_DISTR set access_constraint_descr='*not filled' where access_constraint_descr is NULL;
update LOAD_DISTR set    use_constraint_descr='*not filled' where    use_constraint_descr is NULL;
--
insert into DISTRIBUTION (entry_id, data_size,             access_type_id,        format_id, 
            fees_id,                use_constraint_id,                   access_constraint_id)
  select                  entry_id, data_size, ACCESS_TYPE.access_type_id, FORMAT.format_id,
       FEES.fees_id, USE_CONSTRAINT.use_constraint_id, ACCESS_CONSTRAINT.access_constraint_id
  from LOAD_DISTR, ACCESS_TYPE, FORMAT, FEES, USE_CONSTRAINT, ACCESS_CONSTRAINT
 where LOAD_DISTR.access_acronym          = ACCESS_TYPE.access_acronym   
   and LOAD_DISTR.format_acronym          = FORMAT.format_acronym   
   and LOAD_DISTR.fees_acronym            = FEES.fees_acronym   
   and LOAD_DISTR.access_constraint_descr = ACCESS_CONSTRAINT.constraint_descr
   and LOAD_DISTR.use_constraint_descr    = USE_CONSTRAINT.constraint_descr;
