× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.