|
Oliver, You can use the build-in function DECIMAL or ZONED to create a packed or zoned field in QUERY and assign a length as well. Something like, SELECT itemcode, DECIMAL(quantity, 7, 0) It may look like a patch, but if you can solve your problem with this, then use it. Regards, Carel Teijgeler. *********** REPLY SEPARATOR *********** On 3-8-04 at 10:38 oliver.wenzel@xxxxxxxxxxxxxxxxxxxxxxx wrote: >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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.