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     [CLOSED] PRINT command using ACTUAL format instead of USAGE format?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] PRINT command using ACTUAL format instead of USAGE format?
 Login/Join
 
Dan Pinault
Guru
posted
Greetings all you FOCUSed folks!

This is strange. I have a master file for a SQLMSS table. One of the fields in the SQLMSS table is a decimal(18,2) format. When the synonym was created, the ACTUAL data type came across as P10 and I set the USAGE to D20.2.

Now, if I run this TABLE request...
TABLE FILE MYSQLFILE
SUM
FST.DECIMALFIELD
BY DECIMALFIELD
END

I get the 'proper' values in my results (i.e. .25, 1.73, 3.99, 5.00, etc.)

HOWEVER, if I run this TABLE request...
TABLE FILE MYSQLFILE
PRINT
DECIMALFIELD
END

I get the wrong values in my results (i.e. .00, .00, 2.00, 4.00, 5.00, etc.)

It's as if the PRINT command is using the ACTUAL data type from the master file and the SUM command is using the USAGE data type from the master file. In fact, if I change the ACTUAL data type in the master file to D8.2 I get the correct results using PRINT and/or SUM.

Have you ever seen this before? Why would different verb commands use different data types from a master file?!?

un-FOCUSed,

Dan

This message has been edited. Last edited by: Dan Pinault,


7.7.05M/7.7.03 HF6 on Windows Server 2003 SP2 output to whatever is required.
 
Posts: 393 | Location: St. Paul, MN | Registered: November 06, 2007Report This Post
Waz
Expert
posted Hide Post
Very interesting,

Is there a difference in the SQL generated ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Dan Pinault
Guru
posted Hide Post
Waz,

With respect to the examples above...

 AGGREGATION DONE ...
 SELECT			"DECIMALFIELD", 
 			MIN("DECIMALFIELD") 
 FROM			"MYSQLSERVER"."dbo"."MYSQLFILE" 
 GROUP BY 		"DECIMALFIELD"
 ORDER BY 		"DECIMALFIELD";



 FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
 FOC2594 - AGGREGATION IS NOT APPLICABLE TO THE VERB USED
 SELECT DISTINCT	"DECIMALFIELD" 
 FROM 			"MYSQLSERVER"."dbo"."MYSQLFILE" 
 ORDER BY 		"DECIMALFIELD";


Pretty much what I would expect. Nothing here that would round my numbers.

Very odd indeed.

Dan


7.7.05M/7.7.03 HF6 on Windows Server 2003 SP2 output to whatever is required.
 
Posts: 393 | Location: St. Paul, MN | Registered: November 06, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
I just tested this and the Master is generated with USAGE=P20.2, ACTUAL=P10. With this format, both requests work as expected. If I change the P20.2 to D20.2 I get what you describe, which leads me to believe P10 and D20.2 are not compatible.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
Reference: ACTUAL to USAGE Conversion
The following conversions from ACTUAL format to USAGE (display) format are permitted:
ACTUAL USAGE
A      A, D, F, I, P, date format, date-time format
D      D
DATE   date format
F      F 
H      H
I      I, date format
P      P, date format
Z      D, F, I, P


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
GamP
Virtuoso
posted Hide Post
So, if you have an actual P, you can only use P or date as USAGE? Makes sense.
The master is generated with P format as actual, but you can change that manually to D. If you do that, then you should specify D8 - this indicates a normal decimal field. Add the decimals in the usage, not the actual.
D'you think there's a setting that will automatically create the D-actual in stead of the P-actual?


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Dan Pinault
Guru
posted Hide Post
Thanks folks for the additional information. I guess I need to become more familiar with the data formats. Is there a general rule-of-thumb for deciding whether to use P or D?


7.7.05M/7.7.03 HF6 on Windows Server 2003 SP2 output to whatever is required.
 
Posts: 393 | Location: St. Paul, MN | Registered: November 06, 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     [CLOSED] PRINT command using ACTUAL format instead of USAGE format?

Copyright © 1996-2020 Information Builders