-- -------------------------------------------------------------
-- loadCHECKload_nnw.sql:
-- This SQL script is to check the content of the loading layer
--   here: just warning for fields that contain NULL
--   It is called from SQL script loadCHECK.sql.
--                                                ft, 1999.07.20
-- -------------------------------------------------------------
-- 1: no NULLS recommended in the column
-- -------------------------------------------------------------
insert into LOAD_ERROR_MESSAGES select distinct 
       15, L.entry_id, LOAD_ENTRY.entry_acronym, 'LOAD_&1', 'WARNUL', '&2=NULL found!'
  from  LOAD_&1 L, LOAD_ENTRY where L.&2 is NULL
   and  L.entry_id = LOAD_ENTRY.entry_id;
-- The END of loadCHECKnew_nnw.sql
