-- This SQL script searches for any NULL entries in any of CERA's columns.
-- There should be none, as NULL values are not allowed in any CERA column!
-- In this list CERA Core and CERA Modules DATA_ORGANIZATION + DATA_ACCESS 
-- are included.                                                ft, 8.9.98
SET LINESIZE 130
SET PAGESIZE 5000
SET PAUSE OFF
SET TRIMSPOOL ON
SET TRIMOUT ON
SET VERIFY OFF
spool nullCheck

select * from ACCESS_CONSTRAINT where ACCESS_CONSTRAINT_ID        is NULL;
select * from ACCESS_CONSTRAINT where CONSTRAINT_DESCR            is NULL;
select * from ACCESS_STRUCTURE  where ACCESS_STRUCTURE_ID         is NULL;
select * from ACCESS_STRUCTURE  where ACCESS_STRUCTURE_NAME       is NULL;
select * from ACCESS_STRUCTURE  where ACCESS_STRUCTURE_DESCR      is NULL;
select * from ACCESS_TYPE       where ACCESS_TYPE_ID              is NULL;
select * from ACCESS_TYPE       where ACCESS_ACRONYM              is NULL;
select * from ACCESS_TYPE       where ACCESS_DESCR                is NULL;
select * from AGGREGATION       where AGGREGATION_ID              is NULL;
select * from AGGREGATION       where AGGREGATION_DESCR           is NULL;
select * from CAMPAIGN          where ENTRY_ID                    is NULL;
select * from CAMPAIGN          where PROJECT_ID                  is NULL;
select * from CITATION          where CITATION_ID                 is NULL;
select * from CITATION          where TITLE                       is NULL;
select * from CITATION          where AUTHORS                     is NULL;
select * from CITATION          where PUBLICATION                 is NULL;
select * from CITATION          where PUBLISHER                   is NULL;
select * from CITATION          where EDITOR                      is NULL;
select * from CITATION          where PUBLICATION_DATE            is NULL;
select * from CITATION          where COUNTRY                     is NULL;
select * from CITATION          where STATE                       is NULL;
select * from CITATION          where PLACE                       is NULL;
select * from CITATION          where EDITION                     is NULL;
select * from CITATION          where ACCESS_SPEC                 is NULL;
select * from CITATION          where PRESENTATION_ID             is NULL;
select * from CITATION          where CITATION_TYPE_ID            is NULL;
select * from CITATION_TYPE     where CITATION_TYPE_ID            is NULL;
select * from CITATION_TYPE     where CITATION_TYPE               is NULL;
select * from CITATION_TYPE     where CITATION_TYPE_DESCR         is NULL;
select * from CONNECT_TYPE      where CONNECT_TYPE_ID             is NULL;
select * from CONNECT_TYPE      where CONNECT_TYPE                is NULL;
select * from CONNECT_TYPE      where CONNECT_DESCR               is NULL;
select * from CONTACT           where ENTRY_ID                    is NULL;
select * from CONTACT           where INSTITUTE_ID                is NULL;
select * from CONTACT           where PERSON_ID                   is NULL;
select * from CONTACT           where CONTACT_TYPE_ID             is NULL;
select * from CONTACT_TYPE      where CONTACT_TYPE_ID             is NULL;
select * from CONTACT_TYPE      where CONTACT_TYPE                is NULL;
select * from COVERAGE          where ENTRY_ID                    is NULL;
select * from COVERAGE          where TEMPORAL_COVERAGE_ID        is NULL;
select * from COVERAGE          where SPATIAL_COVERAGE_ID         is NULL;
select * from CURRENTNESS_REF   where CURRENTNESS_REF_ID          is NULL;
select * from CURRENTNESS_REF   where CURRENTNESS_REF_DESCR       is NULL;
select * from DATA_ACCESS       where DATA_ACCESS_ID              is NULL;
select * from DATA_ACCESS       where ACCESS_STRUCTURE_ID         is NULL;
select * from DATA_ACCESS       where STORAGE1_ID                 is NULL;
select * from DATA_ACCESS       where STORAGE2_ID                 is NULL;
select * from DATA_ACCESS       where STORAGE3_ID                 is NULL;
select * from DATA_ACCESS       where STORAGE4_ID                 is NULL;
select * from DATA_ACCESS       where REC_STRUCTURE_ID            is NULL;
select * from DATA_ACCESS       where MODIFICATION_DATE           is NULL;
select * from DATA_ORG          where DATA_ORG_ID                 is NULL;
select * from DATA_ORG          where DATA_ORG_DESCR              is NULL;
select * from DATA_ORG          where SPACE_ID                    is NULL;
select * from DATA_ORG          where TIME_ID                     is NULL;
select * from DIF_ENTRY         where ENTRY_ID                    is NULL;
select * from DIF_ENTRY         where DIF_TITLE                   is NULL;
select * from DIF_ENTRY         where DIF_NAME                    is NULL;
select * from DIM_TYPE          where DIM_TYPE_ID                 is NULL;
select * from DIM_TYPE          where DIM_TYPE_NAME               is NULL;
select * from DISTRIBUTION      where ENTRY_ID                    is NULL;
select * from DISTRIBUTION      where ACCESS_TYPE_ID              is NULL;
select * from DISTRIBUTION      where DATA_SIZE                   is NULL;
select * from DISTRIBUTION      where FORMAT_ID                   is NULL;
select * from DISTRIBUTION      where FEES_ID                     is NULL;
select * from DISTRIBUTION      where ACCESS_CONSTRAINT_ID        is NULL;
select * from DISTRIBUTION      where USE_CONSTRAINT_ID           is NULL;
select * from ENTRY             where ENTRY_ID                    is NULL;
select * from ENTRY             where ENTRY_NAME                  is NULL;
select * from ENTRY             where ENTRY_ACRONYM               is NULL;
select * from ENTRY             where ENTRY_TYPE_ID               is NULL;
select * from ENTRY             where SUMMARY_ID                  is NULL;
select * from ENTRY             where QUALITY_ID                  is NULL;
select * from ENTRY             where PROGRESS_ID                 is NULL;
select * from ENTRY             where CREATION_DATE               is NULL;
select * from ENTRY             where REVIEW_DATE                 is NULL;
select * from ENTRY             where REVISION_DATE               is NULL;
select * from ENTRY             where FUTURE_REVIEW_DATE          is NULL;
select * from ENTRY_CONNECT     where GEN_ENTRY_ID                is NULL;
select * from ENTRY_CONNECT     where SPEC_ENTRY_ID               is NULL;
select * from ENTRY_CONNECT     where CONNECT_TYPE_ID             is NULL;
select * from ENTRY_TYPE        where ENTRY_TYPE_ID               is NULL;
select * from ENTRY_TYPE        where ENTRY_TYPE                  is NULL;
select * from ENTRY_TYPE        where ENTRY_TYPE_DESCR            is NULL;
select * from FEES              where FEES_ID                     is NULL;
select * from FEES              where FEES_ACRONYM                is NULL;
select * from FEES              where FEES_DESCR                  is NULL;
select * from FORMAT            where FORMAT_ID                   is NULL;
select * from FORMAT            where FORMAT_ACRONYM              is NULL;
select * from FORMAT            where FORMAT_DESCR                is NULL;
select * from GENERAL_KEY       where GENERAL_KEY_ID              is NULL;
select * from GENERAL_KEY       where GENERAL_KEY                 is NULL;
select * from HOR_COORD_SYS     where HOR_COORD_SYS_ID            is NULL;
select * from HOR_COORD_SYS     where SYS_DESCR                   is NULL;
select * from INSTITUTE         where INSTITUTE_ID                is NULL;
select * from INSTITUTE         where INSTITUTE_NAME              is NULL;
select * from INSTITUTE         where INSTITUTE_ACRONYM           is NULL;
select * from INSTITUTE         where DEPARTMENT_NAME             is NULL;
select * from INSTITUTE         where DEPARTMENT_ACRONYM          is NULL;
select * from INSTITUTE         where COUNTRY                     is NULL;
select * from INSTITUTE         where STATE_OR_PROVINCE           is NULL;
select * from INSTITUTE         where PLACE                       is NULL;
select * from INSTITUTE         where STREET                      is NULL;
select * from INSTITUTE         where STREET_POSTAL_CODE          is NULL;
select * from INSTITUTE         where POBOX                       is NULL;
select * from INSTITUTE         where POBOX_POSTAL_CODE           is NULL;
select * from INSTITUTE         where URL                         is NULL;
select * from INSTITUTE         where ADDITIONAL_INFO             is NULL;
select * from KEY_CONNECT       where ENTRY_ID                    is NULL;
select * from KEY_CONNECT       where GENERAL_KEY_ID              is NULL;
select * from LOCATION          where LOCATION_ID                 is NULL;
select * from LOCATION          where LOCATION_NAME               is NULL;
select * from LOCATION          where LOCATION_POINTER            is NULL;
select * from LOCATION          where LOCATION_LEVEL              is NULL;
select * from LOCATION          where REF_DATE                    is NULL;
select * from LOCATION          where MIN_LAT                     is NULL;
select * from LOCATION          where MAX_LAT                     is NULL;
select * from LOCATION          where MIN_LON                     is NULL;
select * from LOCATION          where MAX_LON                     is NULL;
select * from LOCATION_CONNECT  where ENTRY_ID                    is NULL;
select * from LOCATION_CONNECT  where LOCATION_ID                 is NULL;
select * from MOMENT            where MOMENT_ID                   is NULL;
select * from MOMENT            where MOMENT_NAME                 is NULL;
select * from MOMENT            where YEAR                        is NULL;
select * from MOMENT            where MONTH                       is NULL;
select * from MOMENT            where DAY                         is NULL;
select * from MOMENT            where HOUR                        is NULL;
select * from MOMENT            where MINUTE                      is NULL;
select * from MOMENT            where SECOND                      is NULL;
select * from MOMENT            where UTC_DIFFERENCE              is NULL;
select * from PARAMETER         where ENTRY_ID                    is NULL;
select * from PARAMETER         where TOPIC_ID                    is NULL;
select * from PARAMETER         where UNIT_ID                     is NULL;
select * from PARAMETER         where AGGREGATION_ID              is NULL;
select * from PARAMETER         where SPATIAL_DATA_ORG_ID         is NULL;
select * from PARAMETER         where DATA_ORG_ID                 is NULL;
select * from PARAMETER         where DATA_ACCESS_ID              is NULL;
select * from PERSON            where PERSON_ID                   is NULL;
select * from PERSON            where FIRST_NAME                  is NULL;
select * from PERSON            where SECOND_NAME                 is NULL;
select * from PERSON            where LAST_NAME                   is NULL;
select * from PERSON            where TITLE                       is NULL;
select * from PERSON            where INSTITUTE_ID                is NULL;
select * from PERSON            where TELEPHONE                   is NULL;
select * from PERSON            where FAX                         is NULL;
select * from PERSON            where URL                         is NULL;
select * from PERSON            where EMAIL                       is NULL;
select * from POINT             where POINT_ID                    is NULL;
select * from POINT             where POINT_NAME                  is NULL;
select * from POINT             where LATITUDE                    is NULL;
select * from POINT             where UNIT_LAT_ID                 is NULL;
select * from POINT             where LONGITUDE                   is NULL;
select * from POINT             where UNIT_LON_ID                 is NULL;
select * from POINT             where ALTITUDE                    is NULL;
select * from POINT             where UNIT_ALT_ID                 is NULL;
select * from POINT_CONNECT     where POINT_SET_ID                is NULL;
select * from POINT_CONNECT     where POINT_ID                    is NULL;
select * from POINT_CONNECT     where MOMENT_ID                   is NULL;
select * from POINT_CONNECT     where SEQUENCE_NO                 is NULL;
select * from POINT_SET         where POINT_SET_ID                is NULL;
select * from POINT_SET         where POINT_SET_NAME              is NULL;
select * from POINT_SET         where NUM_POINTS                  is NULL;
select * from POSITION          where POSITION_ID                 is NULL;
select * from POSITION          where POSITION_NAME               is NULL;
select * from POSITION          where POSITION_VALUE              is NULL;
select * from POSITION          where UNIT_ID                     is NULL;
select * from PRESENTATION      where PRESENTATION_ID             is NULL;
select * from PRESENTATION      where PRESENTATION_DESCR          is NULL;
select * from PROCESS_STEP      where ENTRY_ID                    is NULL;
select * from PROCESS_STEP      where PROCESS_DESCR               is NULL;
select * from PROCESS_STEP      where PROCESS_DATE                is NULL;
select * from PROCESS_STEP      where PERSON_ID                   is NULL;
select * from PROGRESS          where PROGRESS_ID                 is NULL;
select * from PROGRESS          where PROGRESS_DESCR              is NULL;
select * from PROJECT           where PROJECT_ID                  is NULL;
select * from PROJECT           where PROJECT_ACRONYM             is NULL;
select * from PROJECT           where PROJECT_NAME                is NULL;
select * from PROJECT           where PROJECT_DESCR               is NULL;
select * from QUALITY           where QUALITY_ID                  is NULL;
select * from QUALITY           where ACCURACY_REPORT             is NULL;
select * from QUALITY           where CONSISTENCY_REPORT          is NULL;
select * from QUALITY           where COMPLETENESS_REPORT         is NULL;
select * from QUALITY           where HORIZONTAL_ACC_REPORT       is NULL;
select * from QUALITY           where VERTICAL_ACC_REPORT         is NULL;
select * from REC_STRUCTURE     where REC_STRUCTURE_ID            is NULL;
select * from REC_STRUCTURE     where STRUCTURE_NAME              is NULL;
select * from REC_STRUCTURE     where DIM1_TYPE                   is NULL;
select * from REC_STRUCTURE     where DIM1_ID                     is NULL;
select * from REC_STRUCTURE     where DIM2_TYPE                   is NULL;
select * from REC_STRUCTURE     where DIM2_ID                     is NULL;
select * from REC_STRUCTURE     where DIM3_TYPE                   is NULL;
select * from REC_STRUCTURE     where DIM3_ID                     is NULL;
select * from REC_STRUCTURE     where DIM4_TYPE                   is NULL;
select * from REC_STRUCTURE     where DIM4_ID                     is NULL;
select * from REC_STRUCTURE     where DIM5_TYPE                   is NULL;
select * from REC_STRUCTURE     where DIM5_ID                     is NULL;
select * from REFERENCE         where ENTRY_ID                    is NULL;
select * from REFERENCE         where CITATION_ID                 is NULL;
select * from REFERENCE         where REF_TYPE_ID                 is NULL;
select * from REF_TYPE          where REF_TYPE_ID                 is NULL;
select * from REF_TYPE          where REF_TYPE_DESCR              is NULL;
select * from SCALE             where SCALE_ID                    is NULL;
select * from SCALE             where SCALE_NAME                  is NULL;
select * from SCALE             where NUM_POINTS                  is NULL;
select * from SCALE             where DIM_TYPE_ID                 is NULL;
select * from SCALE_CONNECT     where SCALE_ID                    is NULL;
select * from SCALE_CONNECT     where POSITION_ID                 is NULL;
select * from SCALE_CONNECT     where SEQUENCE_NO                 is NULL;
select * from SPACE             where SPACE_ID                    is NULL;
select * from SPACE             where SPACE_DESCR                 is NULL;
select * from SPACE             where LAT_SCALE_ID                is NULL;
select * from SPACE             where LON_SCALE_ID                is NULL;
select * from SPACE             where ALT_SCALE_ID                is NULL;
select * from SPACE             where POINT_SET_ID                is NULL;
select * from SPATIAL_COVERAGE  where SPATIAL_COVERAGE_ID         is NULL;
select * from SPATIAL_COVERAGE  where MIN_LAT                     is NULL;
select * from SPATIAL_COVERAGE  where MAX_LAT                     is NULL;
select * from SPATIAL_COVERAGE  where MIN_LON                     is NULL;
select * from SPATIAL_COVERAGE  where MAX_LON                     is NULL;
select * from SPATIAL_COVERAGE  where MIN_ALTITUDE                is NULL;
select * from SPATIAL_COVERAGE  where MAX_ALTITUDE                is NULL;
select * from SPATIAL_COVERAGE  where MIN_ALT_UNIT_ID             is NULL;
select * from SPATIAL_COVERAGE  where MAX_ALT_UNIT_ID             is NULL;
select * from SPATIAL_DATA_ORG  where SPATIAL_DATA_ORG_ID         is NULL;
select * from SPATIAL_DATA_ORG  where REFERENCE_METHOD            is NULL;
select * from SPATIAL_REFERENCE where ENTRY_ID                    is NULL;
select * from SPATIAL_REFERENCE where HOR_COORD_SYS_ID            is NULL;
select * from SPATIAL_REFERENCE where VER_COORD_SYS_ID            is NULL;
select * from STORAGE           where STORAGE_ID                  is NULL;
select * from STORAGE           where STORAGE_NAME                is NULL;
select * from SUMMARY           where SUMMARY_ID                  is NULL;
select * from SUMMARY           where SUMMARY                     is NULL;
select * from TEMPORAL_COVERAGE where TEMPORAL_COVERAGE_ID        is NULL;
select * from TEMPORAL_COVERAGE where START_YEAR                  is NULL;
select * from TEMPORAL_COVERAGE where START_MONTH                 is NULL;
select * from TEMPORAL_COVERAGE where START_DAY                   is NULL;
select * from TEMPORAL_COVERAGE where STOP_YEAR                   is NULL;
select * from TEMPORAL_COVERAGE where STOP_MONTH                  is NULL;
select * from TEMPORAL_COVERAGE where STOP_DAY                    is NULL;
select * from TEMPORAL_COVERAGE where CURRENTNESS_REF_ID          is NULL;
select * from TIME              where TIME_ID                     is NULL;
select * from TIME              where TIME_NAME                   is NULL;
select * from TIME              where NUM_POINTS                  is NULL;
select * from TIME              where DIM_TYPE_ID                 is NULL;
select * from TIME_CONNECT      where TIME_ID                     is NULL;
select * from TIME_CONNECT      where MOMENT_ID                   is NULL;
select * from TOPIC             where TOPIC_ID                    is NULL;
select * from TOPIC             where TOPIC_NAME                  is NULL;
select * from TOPIC             where TOPIC_ACRONYM               is NULL;
select * from TOPIC             where TOPIC_DESCR                 is NULL;
select * from TOPIC             where TOPIC_POINTER               is NULL;
select * from TOPIC             where TOPIC_LEVEL                 is NULL;
select * from TOPIC_OLD         where TOPIC_ID                    is NULL;
select * from TOPIC_OLD         where TOPIC_NAME                  is NULL;
select * from TOPIC_OLD         where TOPIC_ACRONYM               is NULL;
select * from TOPIC_OLD         where TOPIC_DESCR                 is NULL;
select * from TOPIC_OLD         where TOPIC_POINTER               is NULL;
select * from TOPIC_OLD         where TOPIC_LEVEL                 is NULL;
select * from UNIT              where UNIT_ID                     is NULL;
select * from UNIT              where UNIT_NAME                   is NULL;
select * from UNIT              where UNIT_ACRONYM                is NULL;
select * from UNIT              where UNIT_DESCR                  is NULL;
select * from USE_CONSTRAINT    where USE_CONSTRAINT_ID           is NULL;
select * from USE_CONSTRAINT    where CONSTRAINT_DESCR            is NULL;
select * from VER_COORD_SYS     where VER_COORD_SYS_ID            is NULL;
select * from VER_COORD_SYS     where SYS_DESCR                   is NULL;

spool off
SET VERIFY ON
SET PAUSE ON
SET PAGESIZE 36
