Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] -SET Calculation displaying asterisks ****** in FOCUS
 Login/Join
 
Rhonda
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, 2007Report This Post
j.gross
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, 2005Report This Post
Rhonda
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, 2007Report This Post
Tony A
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: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Danny-SRL
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: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Rhonda
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, 2007Report This Post
RSquared
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, 2008Report This Post
Rhonda
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, 2007Report This Post
susannah
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, 2003Report This Post
Doug
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: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Rhonda
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, 2007Report This Post
Twanette
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: 195 | Location: Johannesburg, South Africa | Registered: September 13, 2008Report This Post
Tony A
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: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Rhonda
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, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders