HOME UP

CERA SQL: tools for loading layer

The following SQL scripts can be found on this page:
- getLOAD.sql: to make a list of the loading layer's contents
- loadCHECKEDdata.sql: to transfer the tables LOAD_* of the loading layer to the appropriate CERA-2 tables by using the load_*.sql files as subroutines (see below).
- loadCHECKEDvalues.sql: to transfer the tables NEW_* of the loading layer (=new contributions to the LOVs) to the appropriate CERA-2 tables.
- 15 files loadCHECK*.sql to check the loading layer tables for consistency before transferring them into CERA. MIND: all loadCHECK* are included as procedures in the ORACLE Form "loadMDB", triggered by a "CHECK" button.
- - loadCHECK.sql: to do the necessary settings and to call all check routines:
- - 8 files loadCHECKload*.sql: to check the files LOAD_* of the loading layer:
- - - loadCHECKload_eid.sql: checking for LOAD_ENTRY.entry_id
- - - loadCHECKload_id.sql: checking for LOAD_*.entry_id
- - - loadCHECKload_lch.sql: checking for LOV char fields
- - - loadCHECKload_lcx.sql: checking for LOV char fields (extended version)
- - - loadCHECKload_lid.sql: checking for LOV id fields
- - - loadCHECKload_lix.sql: checking for LOV id fields (extended version)
- - - loadCHECKload_nnf.sql: checking for NOT NULL fatals
- - - loadCHECKload_nnw.sql: checking for NOT NULL warnings
- - 6 files loadCHECKnew*.sql: to check the files NEW_* of the loading layer:
- - - loadCHECKnew_ch.sql: checking for LOV char fields
- - - loadCHECKnew_id.sql: checking for LOV id fields
- - - loadCHECKnew_in.sql: checking for inclusion of items in an LOV column
- - - loadCHECKnew_lc.sql: checking bounding boxes of table NEW_LOCATION
- - - loadCHECKnew_nn.sql: checking for NOT NULL
- - - loadCHECKnew_pt.sql: checking for pointer consistency in hierarchical tables.
- loadGRANTS.sql: to give grants on CERA loading layer tables and sequences.
- loadRESET.sql: to delete all rows from all tables of the loading layer.
- 10 files load_*: to transfer the CERA Blocks' contents from the loading layer to CERA-2.

Go to bottom of document

Oct 27 1998 : getLOAD.sql ( 1233 Bytes )

Aug 05 17:21 : loadCHECK.sql ( 12969 Bytes )

Jul 21 15:42 : loadCHECKEDdata.sql ( 414 Bytes )

Aug 05 17:41 : loadCHECKEDvalues.sql ( 16375 Bytes )

Aug 05 13:10 : loadCHECKload_eid.sql ( 1083 Bytes )

Aug 05 13:10 : loadCHECKload_id.sql ( 1418 Bytes )

Aug 05 13:32 : loadCHECKload_lch.sql ( 1219 Bytes )

Aug 05 13:14 : loadCHECKload_lcx.sql ( 1430 Bytes )

Aug 05 13:16 : loadCHECKload_lid.sql ( 1333 Bytes )

Aug 05 13:17 : loadCHECKload_lix.sql ( 1446 Bytes )

Aug 05 13:02 : loadCHECKload_nnf.sql ( 752 Bytes )