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