AS400/Query Problem


Iam trying to write out a file that can be added to the F3002 file. The
problem I run into is that some of the fields need to have new values in
them, like IXQNTY needs to have a value of 1.00. When Query writes out this
field, the resultant field is unpacked. Is there a way I can get around
this without writing an RPG program? Currently I will have to run a query
to create the new file, but then I will have to use World Writer to go
update the value to the correct value.

Michael Grejtak, CPIM
JDEdwards Manufacturing Systems Analyst
Planning/Inventory/Shop Floor Control
Hancor, Inc.


Well Known Member
There is a Query400 command named |digits| that can be used in the "define
results field" that may do the trick. Use F1 on the "expression" field to
find it.