Importing Text Using SQL*Loader Example - Intergraph Smart Reference Data - Help - Hexagon PPM

Intergraph Smart Reference Data Help Classic (2020)

PPMProduct
Intergraph Smart Reference Data
PPMCategory_custom
Help
Version_SPMat_custom
2020 (10.0)

  • Intergraph PDS documentation contains a listing of Zydex and model codes with their descriptions.

  1. Copy the list of Zydex and model codes and their descriptions from the PDS documentation into a text editor.

  2. Replace all tabs, equal symbols, and single quotes with spaces.

    Component Sort by AABBCC Code

    AABBCCCode Model Code Description

    6Q1C01 GAT gate valve

    6Q1C02 GATEX extended body gate valve

    6Q1C03 GATCON conduit gate valve

    6Q1C04 GATBL blank gate valve

    6Q1C05 3WV valve (3-way)

    ...

  3. Remove the first two lines and add the item type that you want to assign to this data. The level defaults to DETAIL; the NLS ID defaults to 1 (English); and, the tir_id is filled with a sequence. The Description field inherits the text present in the short description. All required information is now present to import the data as shown in the following example without using the S.20.10 screen as presented earlier in this document. (See the Table Import via S.20.10 section.)

    PDS_ZYDEX 6Q1C01 GAT gate valve

    PDS_ZYDEX 6Q1C02 GATEX extended body gate valve

    PDS_ZYDEX 6Q1C03 GATCON conduit gate valve

    PDS_ZYDEX 6Q1C04 GATBL blank gate valve

    PDS_ZYDEX 6Q1C05 3WV valve (3-way)

    ...

The SQL*Loader uses the following control file to import the data:

LOAD DATA

INTO TABLE m_table_import_rows

APPEND

(tir_type POSITION (1:9) CHAR,

tir_code POSITION (11:16) CHAR,

short_desc POSITION (33:60) CHAR

)