Focal Point
[CASE-OPENED] -SET Calculation displaying asterisks ****** in FOCUS

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2147048336

September 30, 2013, 02:01 PM
Rhonda
[CASE-OPENED] -SET Calculation displaying asterisks ****** in FOCUS
Hello everyone code below ran successfully in 7.6.12 now in 7.6.13 ******* are displayed.
-SET &CAPM = 999;
-SET &XSCAP = &CAPM*1000000;
-TYPE &XSCAP
in 7.6.12 &XSCAP displays 9990000000
in 7.6.13 &XSCAP displays *******
-**********************************
If I use FTOA the result is incorrect
-SET &NUM1=999;
-SET &NUM2= FTOA((&NUM1 * 10000000), '(D14)', 'A14');
-TYPE &NUM2 displays 9,990,000
Any recommendations? corrections or another technique? According to my customer this worked in 7.6.5.

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
September 30, 2013, 04:23 PM
j.gross
make that
-SET &NUM2= FTOA((&NUM1 * 10000000), '(D10)', 'A14');
and you'll get the full answer
9,990,000,000
September 30, 2013, 05:05 PM
Rhonda
Thank you! I had to increase the size to A30 to get it to display properly.

Rhonda


WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
October 01, 2013, 01:54 AM
Tony A
or ....
-SET &NUM4= FTOA((&NUM1 * 10000000), '(D10c)', 'A14');
If you want it without the comma seperators.

Don't forget SET DMPRECISION when you want to play with decimal places in Dialog Manager.


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
October 01, 2013, 02:06 AM
Danny-SRL
quote:
-SET &CAPM = 999;
-SET &XSCAP = &CAPM*1000000;
-TYPE &XSCAP

In WF 8.0.03 I get 999000000
Maybe a quirk in 7.6.13?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

October 02, 2013, 08:50 AM
Rhonda
I would not be surprised if it is an MVS FOCUS quirk or BUG. We do not have FOCUS 8.x...is it out yet? I will have IBI test it out.
Thanks for all your input.


WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
October 02, 2013, 09:59 AM
RSquared
I got the same ****** when i ran in WF 5.3.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
October 02, 2013, 11:03 AM
Rhonda
Thanks Tony - didn't know you could do that! I miss my manuals with all the notations in the stickies!

Rhonda


WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
October 03, 2013, 11:56 AM
susannah
quote:
DMPRECISION

rhonda, page 187 in the WF Keysheet
its the best thing since the old hardcopies...




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
October 03, 2013, 12:23 PM
Doug
Way to go Susannah, You're goning high-tech now with that new WF Keysheet Smiler My "User Manual release 7.0 Volumne I and II" are right here on my desk...
October 04, 2013, 11:25 AM
Rhonda
A number will be stored as an Integer value in Dialogue Manager and the limit in FOCUS/WebFOCUS is I9 although the calculation itself is done in double-precision. This no longer works in FOCUS 7.6.13 the calculation needs to be 8 digits or less. A ticket has been opened with IBI.

-SET &CAPM = 999;
-SET &ZCAPM = (&CAPM * 1000000);
-TYPE &ZCAPM


WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
October 07, 2013, 02:24 AM
Twanette
Hi Rhonda,

As a matter of interest - did you try the "SET DMPRECISION" command with your example?

I can't remember whether or not it was available in 7.6.x, but perhaps it is worth trying anyhow.


WebFOCUS 8.2.06 mostly Windows Server
October 07, 2013, 06:50 AM
Tony A
If I run
-SET &NUM1=999;
-SET &NUM2= FTOA((&NUM1 * 10000000), '(D14)', 'A14');
-SET &NUM3= FTOA((&NUM1 * 10000000), '(D10)', 'A14');
-SET &NUM4= FTOA((&NUM1 * 10000000), '(D10c)', 'A14');
-? &NUM
in 7.7.03, I get
 &NUM1         = 999
 &NUM2         =      9,990,000
 &NUM3         = 9,990,000,000
 &NUM4         = 9990000000
returned.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
October 07, 2013, 05:43 PM
Rhonda
Yes I did and it did not seem to have any affect on the code. IBI is looking at the issue to see if the limit has been changed.

Cheers!
Rhonda


WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML