Unfortunately SQL*LOader doesn't allow OR operator in the WHEN clause. Multiple conditions can only be applied with AND operator (sigh).
What you can do is to use multiple INTO TABLE clauses in a single controlfile to mimic the behavior of OR conditions, like:
load data
infile 'test.txt'
badfile 'ofasweb.bad'
discardfile 'ofasweb.dcs'
truncate
into table test when REGION = 'REGROLL'
(company position(01:10) char,
time position(11:20) char,........................................)
into table test when REGION = 'WWF'
(company position(01:10) char,
time position(11:20) char,........................................)
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Reply With Quote