MAPFLD IN OPNQRYF

[Guest.Visitor]

On the Opnqryf command when attempting to convert a packed decimal field from a physical file to a character field on the Opnqryfcommand, is it necessary to first map the packed decimal field to a zoned field and then map the zoned field to a character field? Why? Thanks.

[T.Holt]

The easy way to convert a packed field to a character field is with the %DIGITS function. You get only the digits, no decimal point or minus sign. You can also convert packed to zoned, then zoned to character, but that's the long way. It's the way we had to do it on the S/38.<HR> <font color=blue> On Friday, January 22, 1999, 10:29 AM, chris neely wrote: On the Opnqryf command when attempting to convert a packed decimal field from a physical file to a character field on the Opnqryf command, is it necessary to first map the packed decimal field to a zoned field and then map the zoned field to a character field? Why? Thanks. </font>