AS400 SQL

[RiverGuy]

Hi. I'm running a query with a calculated field that derives its calculation from fields with decimal points. I would like my output to not round off my output to an integer. Is there an option in SQL that anyone knows of?

Thanks.

 

[iSeriesCodePoet]

Hmm... search the IBM documentation. There might be a solution. Mike Wills
IBM iSeries (AS/400) Programmer

http://www.koldark.net

Please, if you find my post useful, let me know.

 

[Wernhow]

There are a couple of options, but the most common is;
float( decimal( Value1, 13, 2 ) / decimal( Value2, 9, 3 ) )
or a variation of the statement.
decimal changes the value of "Value1" to a 13,2 field
Float floats the decimal point
You could also enter;
decimal(float(~~~~~~~), 13,2) = results in a 13,2 field

 

[RiverGuy]

Thanks. I was trying pretty much the same thing but without making the whole thing into a float. I'll give yours a try.