how do i ignore rows with first filed NULL

Shell Programming and Scripting
1

I have a file to load in the table, and am using SQLLDR
CONTROL FILE
-----------------------
LOAD DATA
INFILE 'sample.txt'
APPEND
INTO TABLE TEMP_LOAD
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(FIELD1,FIELD2,FIELD3)

Now i have about 10,000 lines in the file
FIELD1 in the table is not null constraint ...

Now i have about 3000 lines with first field NULL in the file ...

How do i ignore those lines ? I know i can increase 'errors=10000' but that is against company policy ...

Does anyone know any condition in sqlldr?

2

try adding WHEN FIELD1!="" in SQLLDR..