create table mybase.sales ( prod char(10) having format $10., totals double having format dollar6. );
select put (totals, dollar10.) as totals from mybase.sales;
select put(13500, comma6.);