Hi,
I have a field in my mas file with format D20.2. For the values 0 in database column for the corresponding field the values are getting displayed like .00.I want to display 0 instead of .00 as it is in database column.Is there any way to handle this? I used SET CENT-ZERO=ON but it is displaying value as 0.00 not 0.Please advice.

Thanks in advance.

You could try dynamic formatting.

DEFINE FILE XYZ
MYFMT/A8 = IF VALUE EQ INT(VALUE) THEN 'D20' ELSE 'D20.2' ;
END
TABLE FILE XYZ
PRINT VALUE/MYFMT
.
.
.
END

The other option is to convert the value to an alpha.

Thanks Waz.It worked.

Yes; thanks! That's a new concept for me, but I can use it!