Control File oii500.ctl - Intergraph Smart Materials - Version 2016 R4 (8.4.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2016)

PPMProduct
Intergraph Smart Materials
PPMCategory_custom
Help
Version_SPMat
2016 R4 (8.4)

Do not modify this file.

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

-- File: oii500.ctl

-- Open Ident Interface

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

Options (Errors = 0, Rows = 2000)

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

LOAD DATA

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

APPEND

INTO TABLE m_sys.m_oii_import_data

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

TRAILING NULLCOLS

(

rec_type TERMINATED BY "|",

f1 TERMINATED BY "|",

f2 TERMINATED BY "|",

f3 CHAR(2000) TERMINATED BY "|",

f4 TERMINATED BY "|",

f5 TERMINATED BY "|",

f6 TERMINATED BY "|",

f7 TERMINATED BY "|",

f8 TERMINATED BY "|",

f9 TERMINATED BY "|",

f10 TERMINATED BY "|"

)

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