SQL Loader - WHEN Clause
I have to validate 2 columns while loading my data.
I tried using this logic.
Need to load RECORD_TYPE in (1, 3).
Send me the syntax for the same.
I tried something like this...
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 '"'
I am getting syntax error.
Click Here to Expand Forum to Full Width