SQL Loader - WHEN Clause

[jmodic]

I tried something like this...
LOAD DATA
APPEND
INTO TABLE IPDR_3G_REL2_TMP
WHEN VENDOR != 'TRA' AND VENDOR != 'HEA'
AND (RECORD_TYPE = '1' OR RECORD_TYPE = '3')
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS

I am getting syntax error.

The problem is OR operator between the two field conditions in the WHEN clause.

Unfortunately SQL*Loader support only AND operator between different expressions in the WHEN clause.

Maybe it will be easier for you to create a simple check constraint on the table before starting your load.