: MIDRANGE dot COM Mailing List Archive

Zoned and packed fields in query


AddThis Feed Button


Hi,

I have a query running over our order lines file, selecting specific items 
and the ordered quantity.
The selected records are written to a temporary file, and then copied 
(with cpyf *nochk) to the input
file of another program. This works fine. 

However, when I include level break for the item code, and sum up the 
quantity, the quantity field in
the query output file changes from packed to zoned and I get a decimal 
error when I run the program.

Is there any way around this? The input file for the program needs the 
quantity in packed decimal format.

Regards,

Oliver





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2010 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact