Re: AS400 Query and floating point decimal field

Have you tried setting an edit code on the fields?  Hit F16 on the field
from Specify column formatting.

Regards,
-Greg

Gregory Novak
Manager North American Technical Services
Momentum Utilities Pty Ltd
(630) 985-1736
gnovak@xxxxxxxxxx
www.jacana.com
 
Making Information Work for your Business
www.intuator.com

 

-----Original Message-----
From: mandis-inc@xxxxxxx [mailto:mandis-inc@xxxxxxx] 
Sent: Wednesday, February 21, 2007 2:46 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] AS400 Query and floating point decimal field

Bob,  

I tried your suggestion.  I took the quantity field (floating decimal),
multipled by 1 and set the result to be 7.2.  

 Field            Expression                         Column Heading
Len   Dec
 TOTAL       itqty * 1                              total
7     2

Here's the result

               Transaction Qty                              total
000001  1.000000000000000E+000   10000.00E-004

Mike


9.000000000000000E+002   90000.00E-002 
--
Best regards, 

Mike Dreimiller 
Mandis Inc. 
410-526-5996 
Mandis-Inc@xxxxxxx


-------------- Original message from bciervo@xxxxxxxxxxxx: -------------- 

Hi Mike, 
I'm not exactly sure what you are defining as a floating point decimal, 
using the Define result fields, create a new field by multiplying the 
floater field by 1 (which will not change the value, and define the 
created field with 7 and 2 decimals. 



Bob Ciervo 
Programmer/Analyst 
Kinedyne Corporation 
908 231-1800 ext 130 




mandis-inc@xxxxxxx 
Sent by: mapics-l-bounces@xxxxxxxxxxxx 
02/21/2007 07:18 AM 
Please respond to 
MAPICS ERP System Discussion 


To 
MAPICS-L@xxxxxxxxxxxx 
cc 

Subject 
[MAPICS-L] AS400 Query and floating point decimal field 






I am writing an AS400 query. One of the fields is a floating point 
decimal. How would I convert this floating point field to a regular 
decimal (7.2. numeric)? The report writing tool is AS400 query. 

TIA 
-- 
Best regards, 

Mike Dreimiller 
Mandis Inc. 
410-526-5996 
Mandis-Inc@xxxxxxx 
_______________________________________________ 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list 
To post a message email: MAPICS-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/mapics-l 
or email: MAPICS-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/mapics-l. 


_______________________________________________ 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list 
To post a message email: MAPICS-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/mapics-l 
or email: MAPICS-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/mapics-l.