[U2] Unidata calculations incorrect

2009-05-01 Thread Martin Hutchinson
Hi All, We have Unidata 7.2 running on Windows 2008 server making incorrect calculations when numbers are close to zero. I understand there is a 'WIDEZERO' parameter on Univers but I don't think there is an equivalent on Unidata. Below we have an example program and output. 001: BAL =

Re: [U2] Unidata calculations incorrect

2009-05-01 Thread Wally Terhune
look up the ECL statement FLOAT.PRECISION Folks are often happiest with FLOAT.PRECISION 4 Wally Terhune U2 Support Architect IBM Information Management Software Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 Email: wal...@us.ibm.com

RE: [U2] Unidata calculations incorrect

2009-05-01 Thread Colin Alfke
Yes, this is a long running feature of UniData. With a simple statement you can change the results of many of your calculations. Which setting should you use? Well that depends on your data and your calculations. Look at the PRECISION and FLOAT.PRECISION statements (if you don't believe that IBM

RE: [U2] Unidata calculations incorrect

2009-05-01 Thread Nick Gettino
INT Syntax INT(num.expr) Description The UniBasic INT function returns the integer value of numeric expression num.expr. Note: This function does not round num.expr, but truncates decimals. Example In the following example, the program segment prints 1, which is the integer part of the

Re: [U2] Unidata calculations incorrect

2009-05-01 Thread Martin Hutchinson
Thanks Wally and Colin, That works a treat. I am surprised though that Unidata 'out of the box' has this problem and you have to work round it. regards Martin Hutchinson Wally Terhune wrote: look up the ECL statement FLOAT.PRECISION Folks are often happiest with FLOAT.PRECISION 4 Wally

RE: [U2] Unidata calculations incorrect

2009-05-01 Thread Horn, John
Interesting. This works as expected on our system. Unidata 6.something on AIX. I wonder what is different in our settings. :FLOAT.PRECISION FLOAT.PRECISION mode 3 :RUN FIXBP JH.TST BAL [0] BAL = 0 Matches integer MCN BAL = 0

Re: [U2] Unidata calculations incorrect

2009-05-01 Thread Bill Haskett
I got the following for UD v7.2.2 on Windows 2K3 Server w/all SPs :FLOAT.PRECISION FLOAT.PRECISION mode 0 :RUN BP TEST BAL [0] BAL 0 Does not match integer MCN BAL = 0 :FLOAT.PRECISION 4 :RUN BP TEST BAL [0] BAL = 0 Matches integer MCN BAL = 0 Bill

[U2] Forcing Paragraph Input to Uppercase?

2009-05-01 Thread George Gallen
How can you force paragraph supplied data to be uppercase? ie. TEST 001 PA 002 SELECT FILE WITH @ID = I2,ITEM TEST HELLO But if someone were to enter: TEST hello I want the convert the ITEM form hello to HELLO Possible in a Paragraph UV/Information flavor George --- u2-users mailing

Re: [U2] [UV] Type 30 Semaphore Stuck - HELP!!!

2009-05-01 Thread Richard Nuckolls
Scott, If you have UVNET, there is a work around that I came up with: Create a shadow account with all file pointers that go to dynamically hashed files repointed to the network version of the file name, ie myserver!/diskpath. Then repoint your UniObjects to the shadow account. The

Re: [U2] Forcing Paragraph Input to Uppercase?

2009-05-01 Thread kishor
Try TEST 001 PA 002 SELECT FILE WITH @ID = I2,ITEM,(MCU) Regards, Kishor Quoting George Gallen ggal...@wyanokegroup.com: How can you force paragraph supplied data to be uppercase? ie. TEST 001 PA 002 SELECT FILE WITH @ID = I2,ITEM TEST HELLO But if someone were to enter: TEST

Re: [U2] Forcing Paragraph Input to Uppercase?

2009-05-01 Thread Steve Romanow
George Gallen wrote: How can you force paragraph supplied data to be uppercase? ie. TEST 001 PA 002 SELECT FILE WITH @ID = I2,ITEM TEST HELLO But if someone were to enter: TEST hello I want the convert the ITEM form hello to HELLO Possible in a Paragraph

RE: [U2] Unidata calculations incorrect

2009-05-01 Thread Eric Armstrong
Wally, Would this also apply to Universe? FLOAT.PRECISION that is? We also have the same issue with Universe 10.2.10. Eric Armstrong IT Dept -Original Message- From: Wally Terhune [mailto:wal...@us.ibm.com] Sent: Friday, May 01, 2009 6:00 AM To: u2-users@listserver.u2ug.org Subject: Re:

RE: [U2] Forcing Paragraph Input to Uppercase?

2009-05-01 Thread Mark Eastwood
Maybe... WITH @ID = EVAL \UPCASE( I2,ITEM)\ Mark Quoting George Gallen ggal...@wyanokegroup.com: How can you force paragraph supplied data to be uppercase? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] IBM Certification Test - Administering UniData 7.1

2009-05-01 Thread Glenn Batson
Does anyone know how different the real Certification test is from the practice test for the Administering UniData 7.1 test? I know the format is the same and there are about 1 or 2 additional questions added to the number of questions, but are the questions the same and if not how different are

RE: [U2] Forcing Paragraph Input to Uppercase?

2009-05-01 Thread George Gallen
Thanks, That's what I was looking for, where to put the mask at. You can't search for or in the online manuals, wasn't able to track down the other options for inline variable substitution. George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-

RE: [U2] Forcing Paragraph Input to Uppercase?

2009-05-01 Thread Ron Hutchings
Actually, I was able to type HELP at ECL and it found The help message is bit brief. From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Date: Fri, 1 May 2009 13:26:14 -0500 Subject: RE: [U2] Forcing Paragraph Input to Uppercase? Thanks, That's what I was looking for,

Re: [U2] IBM Certification Test - Administering UniData 7.1

2009-05-01 Thread Wally Terhune
none of the questions on the practice test are on the certification tests. no duplications. Every effort was made to make sure the content and difficulty level was the same for the practice test and the real tests. The test development procedure is quite rigorous. Wally Terhune U2 Support