Re: [U2] how to round to 2 decimals?

2010-10-14 Thread John Woollam
Hi I've always used 'R2' e.g. ANS = N1 * N2 'R2' No scaling, just rounding Regards John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Cloud UniVerse

2010-10-14 Thread Augusto Alonso
Hi all. I have a doubt about this. What happens if I have this scenario: - 2 linux boxes with universe installed. Both the same license, but only the active server has Universe started. - a unique shared hard disk that holds my DataBase. - In case of shutdown of the active server, the heartbeat

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Larry Hiscock
Does UniVerse not support the DROUND() function? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 1:02 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals?

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread John Woollam
Hi Never heard of the DROUND() function in Universe. Anyway, why would I want to use a function syntax when I can do ANS = N1 * N2 'R2' and it is the answer that gets rounded? Easy to write. Easy to read... John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC |

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Larry Hiscock
What's so difficult about ANS = DROUND(N1 * N2, 2) ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 8:59 AM To: U2 Users List Subject: Re: [U2] how to round to 2

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Chris Austin
What's the diff between OCONV(X,'MR20') and DROUND(X,2) ?? where X = N1 * N2 From: lar...@wcs-corp.com To: u2-users@listserver.u2ug.org Date: Thu, 14 Oct 2010 09:25:23 -0700 Subject: Re: [U2] how to round to 2 decimals? What's so difficult about ANS = DROUND(N1 * N2, 2) ?

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Chris Austin
Are you sure DROUND() is a UniVerse function? When I do the following code: X = 2596 * 8.333 * PRINT DROUND(X,2) I get the following error: Array 'DROUND' never dimensioned. From: lar...@wcs-corp.com To: u2-users@listserver.u2ug.org Date: Thu, 14 Oct 2010 09:25:23 -0700 Subject: Re:

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Larry Hiscock
No idea if it's been implemented in UV ... it appears not, from your error message. It works in UD shrug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Thursday, October 14, 2010 9:35 AM To:

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Baker Hughes
Would someone like to submit the DROUND function to the BB for a UV enhancement request? If it is already implemented on UD then it should be fairly easy to justify to add to UV. A short business case should be sufficient. Log into U2UG and then click on BetterandBetter link, it will redirect

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Rick Nuckolls
Universe does not have a DROUND() function that I can find. However, at some point a FIX() function was included in the language. :ED BP FIX 5 lines long. : P 0001: ABC = 123.45678 0002: PRINT FIX(ABC,2) 0003: PRINT FIX(ABC, 2, 0) 0004: PRINT FIX(ABC, 2, 1) 0005: END Bottom at line 5.

Re: [U2] Cloud UniVerse

2010-10-14 Thread Michael Pflugfelder
Here's my interpretation of the license: If the heartbeat is done outside of Universe, then it's considered cold. If the heartbeat is done inside of Universe, therefore requiring that Universe be running, it's considered hot. -Mike -Original Message- From:

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread George Gallen
I always used int ( ( x * 10**y) + roundinglevel ) / 10**y where x is the original number, and y is the number of decimals and where roundinglevel is a cutoff, ie (.5 so less than .5 rounds down, and .5 and greater rounds up), if I wanted all number to be rounded up, just use .. And it

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Chris Austin
Thanks George, I know this will be helpful with scaling, I know the need will arise for this in the future. -Chris From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Date: Thu, 14 Oct 2010 12:23:50 -0500 Subject: Re: [U2] how to round to 2 decimals? I always used int

[U2] Restoring Jbase account-save to Universe

2010-10-14 Thread David Ward
Can anyone advise on the best way to restore an account-save to Universe? We get Invalid tape format - level 1 Dsegment missing when we try to use the Universe acct.restore command. We tried skipping the label in varying sizes with no success. Thanks!

Re: [U2] XLr8Editor and Tools Updates

2010-10-14 Thread Bill Brutzman
Doug: I am having trouble locating the install ID, both in the manual and in Eclipse. Please clarify... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Wednesday, October 13, 2010 6:34 PM To:

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Don Robinson
How about this? X = 2596 * 8.333 ;*  [X will contain 21632.468] ANS = INT((X * 100) + .5) / 100 PRINT ANS The (X * 100) changes X to 2163246.8 The + .5 changes X to 2163247.3 The INT() changes X to 2163247 The / 100 changes X to 21632.47 The output will displays 21632.47 Using a FOR

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Chris Austin
Dan, That's pretty cool you got those results actually on your benchmark. I can only imagine why UniVerse would be like that? Maybe it has to look up some libraries with OCONV or do some stupid cross-checking. Either way that's actually a considerable difference if you were in a LOOP with

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Chris Austin
oops.. I should have read your post closer. ' one million times' - so yeah that wouldn't make a huge difference but it's still good to know! -Chris Date: Thu, 14 Oct 2010 11:00:08 -0700 From: donr_w...@yahoo.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] how to round to 2

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread George Gallen
so, when the bank rounds everyones bank balances down the cent, the system would barely pause.maybe noone would noticehmmm. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent:

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread Don Robinson
:-) Yep, no one would notice a half cent!!  Don Robinson From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, October 14, 2010 2:07:00 PM Subject: Re: [U2] how to round to 2 decimals? so, when the bank rounds