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.
Example:
FWT_CONV_CASH_AMT DECIMAL EXTERNAL DEFAULTIF FWT_CONV_CASH_AMT = BLANKS,
![]()




Reply With Quote