Home » RDBMS Server » Server Utilities » Trailing minus in SQLLoader
Trailing minus in SQLLoader [message #368364] Sun, 03 December 2000 19:42
WO
Messages: 1
Registered: December 2000
Junior Member
Is it possible to construct a control file in SQLLoader to accept a trailing minus(positives have no sign or space) and still maintain the direct load.
The data file is tab delimited

A control file that works for leading - sign is
OPTIONS (DIRECT=TRUE)
UNRECOVERABLE
LOAD DATA
INFILE "/dvt/raw_fmit.txt"
BADFILE "/dvt/raw_fmit.bad"
DISCARDFILE "/dvt/raw_fmit.dis"
DISCARDMAX 1
TRUNCATE
PRESERVE BLANKS
INTO TABLE raw_fmit
FIELDS TERMINATED BY X'09'
( wkg001,
wkg002,
wkg003,
wkg004
)
where wkg001,etc. are NUMBER (15,2)
Previous Topic: Server Manager
Next Topic: migrating data
Goto Forum:
  


Current Time: Wed Dec 08 22:41:23 CST 2021