SQL has 3 rounding functions:
1 ROUND - Rounding Commercially, i.e. ,49 --> rounding down / ,5 rounding up
with the 2.nd parameter you can specify the positions to round on
2. CEILING or CEIL always rounds up to the next integer
3. FLOOR always rounds down to the next integer
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of John Yeung
Sent: Mittwoch, 12. Februar 2020 19:35
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: What is a good way to round up numbers in free form?
On Wed, Feb 12, 2020 at 1:14 PM Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:
Or just use SQL ROUND.
Using SQL is definitely sensible advice. The ROUND function in particular
only does half-up rounding, though. To get some of the other methods, you
would need to set the rounding mode and use QUANTIZE. I am actually not
quite clear on how to set the rounding mode; it might not be easy (or even
possible?) to switch modes in the middle of a program.
In that case, having a procedure or procedures to handle different rounding
methods could conceivably be handy. (As a practical matter, I realize it is
extremely unusual to need to dynamically switch rounding
methods.)
John Y.
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
