-- This SQL script resets all CERA columns that are NULL to the default values.
-- The output is logged into null2default.lst. In this list CERA Core and CERA 
-- Modules DATA_ACCESS and DATA_ORGANIZATION are included.        ft, 8.9.1998
SET LINESIZE 130
SET PAGESIZE 5000
SET PAUSE OFF
SET TRIMSPOOL ON
SET TRIMOUT ON
SET VERIFY OFF
spool null2default

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

spool off
SET VERIFY ON
SET PAUSE ON
SET PAGESIZE 36
