I made some progress now. I modified the select statement to:
select cast(cust_id as varchar(7))||','||
acct_type||','||acct_nbr||','||cast(acct_start_date as varchar(8)) ||','||coalesce(cast(acct_end_date as varchar(8)),'00000000')
from financial.accts;
and got the following, which is close to what I need, but any idea where the "-"coming from? Thanks.
- 1362498,SV,0000000013624983,19950915,00000000
- 1362605,CC,4561143213626054,19910111,00000000
- 1362605,SV,0000000013626053,19940326,00000000