Download Utilities User Manual
Transcript
Utilities User Manual 2.22 Part Specification External Catalog This new functionality allows the user to update the HarnesSys Part Specification Libraries with external catalog data. In order to use this functionality, the DBA must create the ORACLE DataBase table shown below. The external catalog must then be accessed and the relevant fields formatted as shown below for each part. The catalog data is then loaded into this HarnesSys ORACLE table. The external data takes precedence in case of conflicts. 2.22.1 DBA Instructions Create the Oracle Part Specification external table as shown above, if not already existent. Create a part specification view in an external file with the following fields: Name NULL? Type /* Comment */ PARTNO NOT NULL VARCHAR2(32) /* Part Number */ MNFCTRRCD NOT NULL VARCHAR2(8) /* Vendor Code */ VARCHAR2(50) /* Part Long description */ VARCHAR2(32) /* Part Description */ INTCATALOGNO VARCHAR2(15) /* Internal Catalog Number */ WEIGHT FLOAT(126) /* Weight */ WEIGHT_UOM VARCHAR2 or NUMBER(38) /* Weight Unit: E(Inch)/M(mm) or 10000-mm 200001-g/mm */ MNFCTRRNM VARCHAR2(20) /* Vendor Name(description) Not Null or value is "From CSM" */ BSCPRTDSCRPT TITLE NOT NULL Users having the External Catalog in formats other than ORACLE, must translate their data accordingly. Create a Data Base Link and Synonym for the Part Specification external table for this project. This example is saved in file ~harness/r11a.00/bin/hr_CSM_install -----------------------------------------------------------------------------------------------------------------#!/bin/csh -f 64 Document Version L Printed copy is for reference only Proprietary