Modify Plate Type Scripts - Intergraph Smart 3D - Reference Data - Hexagon PPM

Intergraph Smart 3D Material Handling Reference Data

Language
English (United States)
Product
Intergraph Smart 3D
Subproduct
Material Handling
Search by Category
Reference Data
Smart 3D Version
13.1

When you create a Material Handling catalog using an empty catalog template (Apprepos.dat or Apprepos.dmp), the software uses marine naming conventions for plate types (for example, Deck, Hull, Longitudinal, and Transverse). You must run scripts on the catalog database schema to change the naming conventions to suit the Material Handling environment. These scripts modify the plate types using the marine naming convention to Horizontal, Planar, SideVertical, and Vertical. These scripts run automatically when you create the catalog database using delivered database templates.

If you use an empty catalog template, you must run the database scripts described below on the catalog database schema.

Scripts for a SQL database

ModifyDeck.sql

Updates the plate type from Deck to Horizontal.

ModifyHull.sql

Updates the plate type from Hull to Planar.

ModifyLongitudinal.sql

Updates the plate type from Longitudinal to SideVertical.

ModifyTransverse.sql

Updates the plate type from Transverse to Vertical.

Script for an ORACLE database

OraMHEBulkload.sql

Updates the plate types from Deck, Hull, Longitudinal, and Transverse to Horizontal, Planar, SideVertical, and Vertical.