Update of CAP
Prerequisites:
- Schema DevV5 with copies of tables concept, concept_relationship and concept_synonym from ProdV5, fully indexed.
- Working directory CAP.
-
Run create_source_tables.sql
-
Get the latest CAP eCC zip-file, extract all xml files from the folder "eCC - All Current Files"
-
Create index file cap_allxmlfilelist.dat: cd /path/to/input/folder/ find . -maxdepth 1 -name "*.xml" > cap_allxmlfilelist.dat
-
Run in devv5 (with fresh vocabulary date and version): SELECT sources.load_input_tables('CAP',TO_DATE('20200226','YYYYMMDD'),'CAP eCC release 20200226');
-
Run load_stage.sql
-
Run generic_update: devv5.GenericUpdate();