Skip to content

Latest commit

 

History

History
 
 

ETC

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 

Update of ETC

Prerequisites:

  • Schema DevV5 with copies of tables concept, concept_relationship and concept_synonym from ProdV5, fully indexed.
  • GCN_SEQNO must be loaded first.
  • Working directory ETC.
  1. Run create_source_tables.sql
  2. Unpack "ETC sources.zip"
  3. Run in devv5: SELECT sources.load_input_tables('ETC'); (The pVocabularyDate and pVocabularyVersion will be automatically retrieved from the GCN_SEQNO)
  4. Run load_stage.sql
  5. Run generic_update: devv5.GenericUpdate();