Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] -SET Calculation displaying asterisks ****** in FOCUS
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED] -SET Calculation displaying asterisks ****** in FOCUS
 Login/Join
 
Platinum Member
posted
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
 
Posts: 146 | Location: Atlanta, GA | Registered: May 31, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
make that
-SET &NUM2= FTOA((&NUM1 * 10000000), '(D10)', 'A14');
and you'll get the full answer
9,990,000,000
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 146 | Location: Atlanta, GA | Registered: May 31, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
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 
 
Posts: 5686 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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

 
Posts: 1961 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 146 | Location: Atlanta, GA | Registered: May 31, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
I got the same ****** when i ran in WF 5.3.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 146 | Location: Atlanta, GA | Registered: May 31, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
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...
 
Posts: 3106 | Location: Tennessee, Nashville area | Registered: February 23, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 146 | Location: Atlanta, GA | Registered: May 31, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 202 | Location: Johannesburg, South Africa | Registered: September 13, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
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 
 
Posts: 5686 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 146 | Location: Atlanta, GA | Registered: May 31, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] -SET Calculation displaying asterisks ****** in FOCUS

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.