Skip to content

Latest commit

 

History

History
11 lines (9 loc) · 526 Bytes

readme.md

File metadata and controls

11 lines (9 loc) · 526 Bytes

Update of ISBT/ISBT Attribute

Prerequisites:

  • Schema DevV5 with copies of tables concept, concept_relationship and concept_synonym from ProdV5, fully indexed.
  • Working directory ISBT
  1. Open http://www.iccbba.org/tech-library/iccbba-documents/databases-and-reference-tables/product-description-codes-database2
  2. Download ISBT-128-Product-Description-Code-Database.accdb and rename to isbt.accdb
  3. Run in devv5: SELECT sources.load_input_tables('ISBT');
  4. Run load_stage.sql
  5. Run generic_update: devv5.GenericUpdate();