Control File oii500.ctl - Intergraph Smart Materials - Version 10.1 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.1

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 ----------