Utility Files and Scripts - Intergraph Smart Materials - Version 2020 (10.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

These utility files perform basic I/O functions for the OMI interface and the B.20.01.44 BOM Download screen. They are on the Smart Materials distribution media, but must be copied to the working directories used for these interfaces.

C.1 SQL*Loader Control Files

-- ----------------------------------------------------------

-- File: omi52onl.ctl

-- OMI interface in Online Mode

--

-- PS 13-DEC-2000: Changed field sizes for OMI 5.2

--

-- ----------------------------------------------------------

Options (Errors = 0, Rows = 2000)

-- ----------------------------------------------------------

LOAD DATA

-- ----------------------------------------------------------

APPEND

INTO TABLE m_sys.m_import_interfaces

WHEN (1:2) <> '--'

TRAILING NULLCOLS

(

kind TERMINATED BY "|",

one TERMINATED BY "|",

two TERMINATED BY "|",

three TERMINATED BY "|",

four TERMINATED BY "|",

five TERMINATED BY "|",

six TERMINATED BY "|",

seven TERMINATED BY "|",

eight TERMINATED BY "|",

nine TERMINATED BY "|",

ten CHAR(2000) TERMINATED BY "|",

eleven CHAR(2000) TERMINATED BY "|",

twelve TERMINATED BY "|",

object TERMINATED BY "|",

rev TERMINATED BY "|",

unit TERMINATED BY "|",

option_code TERMINATED BY "|",

item TERMINATED BY "|",

in_3 TERMINATED BY "|",

in_4 TERMINATED BY "|",

in_5 TERMINATED BY "|",

thirteen TERMINATED BY "|",

fourteen TERMINATED BY "|",

fifteen TERMINATED BY "|",

sixteen TERMINATED BY "|",

seventeen TERMINATED BY "|"

)

-- End of SQL*Loader-Control-File omi52onl.ctl ----------

This file for online loads and the omi52.ctl file for batch loads specify the load options and the Smart Materials table into which the ASCII file is loaded.

You must not modify these files.

The piping_g.ctl control file is used for loading PDS BOM reports into Smart Materials. It has the following structure:

-- Controlfile to import the PDS report output piping_g into

-- SMAT raw data table. This is required for importing PDS data

-- into BOM via OMI (B.40.01)

--

-- 25-JAN-2000 df created

--

LOAD DATA

INTO TABLE m_pds_raw_data

APPEND -- the existing data is handled by m_pck_pds_bom_import

(line SEQUENCE(MAX,1),

text POSITION (1:255) CHAR

)