In Fast Export I am using:
CAST(B.EFF_DT AS DATE format 'YYMMDD')
When this column is NULL in table,it is giving some junk value. How can I modify the fast export so that whenever it is Null, it move Spaces to output file otherwise Date in YYYYMMDD format.
This is giving some junk in output which is behaving as end of line (i suppose) because the next script is reading the recod till that point only. Please let me know how to do that. Thanks again.
The "junk" is probably a 2-byte varchar length, you need to cast the result of the coalesce as a CHAR:
coalesce((B.eff_dt (format 'yyyymmdd') (char(8))), '') (char(8))
Would anyone help with the following : The date is not null. If the date is '2011-01-31', move spaces. Greatly appreciated.
case when(cast((X1_PRODUCT_EFF_DT(format 'YYYY-MM-DD')) as char(10)) is null) then ''
cast((X1_PRODUCT_EFF_DT(format 'YYYY-MM-DD')) as char(10)) end
That worked for me.