Greg

As I understand it, The field is 32 position long and the number is displayed 
as a single decimal with an indicator to the right to show how many position to 
move the decimal to the left or right.

Field               Desc                                                        
 Len  Dec
ITQTY           Transaction Qty                                        16    15

The display of the field in a query is below
1.100000000000000E+003

The +3 indicates to move the decimal 3 positions to the right.

So this value would be 1100 

TIA 

Mike
--
Best regards, 

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


-------------- Original message from "Greg Wenzloff" <GWenzloff@xxxxxxxxxxx>: 
-------------- 


Mike, 

Perhaps I don't understand what you mean by floating point decimal. 
If you mean it has many decimal places and you want to display or print 
a value with only 2 decimal places then do: 

Use Specify Report Column Formatting and change the decimal digits. 

Or 

Use Define Result Field and define a new field with 2 decimal digits and 
display or print the new field. 

Greg 

-----Original Message----- 
From: mandis-inc@xxxxxxx [mailto:mandis-inc@xxxxxxx] 
Sent: Wednesday, February 21, 2007 7:19 AM 
To: MAPICS-L@xxxxxxxxxxxx 
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. 

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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.