sqlloader issue

[sanga]

Hello

Iam trying to load records using sqlloader which have bad date format, due to which the records are going into the bad file, how can I load these bad record date as NULL values

I appreciate any help in this matter

Any work around using sqlloader?

Thanks,

[Horace]

LOAD DATA
INFILE 'z:\MORTGAGE_ACCOUNT.dat'
TRUNCATE INTO TABLE NEWMORTGAGE_ACCOUNT
MA_CMPL_DATE POSITION(357:364) DATE(8) "YYYYMMDD" NULLIF MA_CMPL_DATE = "insert bad date format"