RE: CPYTOIMPF and trailing blanks on numeric fields

Yes it can be done with 
eval      charfield = '''' +          
          %trim(%char(numericfield)) +
               ''''                   
 
Regards, 
 
Guy Henza
Tri-State Hospital Supply Corporation
301 Catrel
Howell MI 48844
fon (517) 546-5400 x1312
fax (517) 540-1513
GHenza@xxxxxxxxx

------------------------------

date: Mon, 26 Sep 2005 11:59:04 +0200
from: "Titus Kruse" <t_kruse@xxxxxxxxx>
subject: CPYTOIMPF and trailing blanks on numeric fields

Hi!

How can I trim trailing blanks on numeric fields written by CPYTOIMPF? I
want to convert data from a DDS described physical file to a standard
CSV-file. The fields in the physical file are packed decimal. Trailing
blanks on character fields can be trimmed by defining character fields
with keyword VARLEN. But this is not allowed for numeric fields. Is
there maybe an edit code in DDS for numeric fields or any other
solution? I don't want to convert them in RPG.

Titus

------------------------------