Re: Zoned and packed fields in query

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.