I have the following as a control file
into table MY_TRANS
when (1) <> "TR"
fields terminated by '|'
FWT_VALUE_DT DATE "YYYYMMDD",
FWT_POST_DT DATE "YYYYMMDD",
The fwt_conv_cash_amt is coming in the file as empty. How do I tell sqlloader if it is empty put a zero in there?
If you look closely in the manual from slimdave's link, you may note that by using the DEFAULTIF clause, the field is set to 0 if the field in the datafile is a numeric field and this clause is satisfied.
FWT_CONV_CASH_AMT DECIMAL EXTERNAL DEFAULTIF FWT_CONV_CASH_AMT = BLANKS,