SQL*Load - 0 into date field

[gopi]

Hello,

I am receiving flat delimitered files where the date is either YYYYMMDD or has just a zero (meaning no date).

Is there a control file clause to convert 0 to null for that column? Otherwise I'll either write some shell script or even C code to transform the 0 data.

Thank You!

[marist89]

http://technet.oracle.com/docs/produ.../ch05.htm#5775

[gopi]

This is what I have learned from the documentation (for anyone else who see's this subject and simply is curious themselves about how to do it).

LOAD DATA
.
.
.
INTO TABLE t1
fields terminated by "," optionally enclosed by '"'
(
col1,
col2,
col3 "DECODE( :col3,
0,NULL,
TO_DATE(:col3,'YYYYMMDD')
)",
col4,
col5
)

Thank you again to all the paient people in this forum.