• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

AS400/Query Problem

MGrejtak

Member
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.
(419)424-8253
 

dale_draper

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.

a7.3c9
v4r4
 
Top