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     [SOLVED]CASE Sensitive

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]CASE Sensitive
 Login/Join
 
Silver Member
posted
I don't know why I am getting these results. The database is MS SQL and is not case sensitive.
It appears to be sensitive to 'PROSTAR' vs 'PROStar' in one case and not another.

-* Row returned
TABLE FILE DW_TRANSPORTATION/EQUIPMENT/NFI_TRACTOR_SNAPSHOT_DAILY
SUM
NFI_TRACTOR_SNAPSHOT_DAILY.VWFACTTRACTORSNAPSHOTDAILY.TRACTOR_DAILYDISPATCHCOUNT
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROSTAR';
END

-* No Row returned
TABLE FILE DW_TRANSPORTATION/EQUIPMENT/NFI_TRACTOR_SNAPSHOT_DAILY
SUM
NFI_TRACTOR_SNAPSHOT_DAILY.VWFACTTRACTORSNAPSHOTDAILY.TRACTOR_DAILYDISPATCHCOUNT
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROStar';
END

-* Row returned
TABLE FILE NFI_TRACTOR_SNAPSHOT_DAILY
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROStar';
END


Trace...
TABLE FILE DW_TRANSPORTATION/EQUIPMENT/NFI_TRACTOR_SNAPSHOT_DAILY
SUM
NFI_TRACTOR_SNAPSHOT_DAILY.VWFACTTRACTORSNAPSHOTDAILY.TRACTOR_DAILYDISPATCHCOUNT
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROSTAR';
END
TABLE FILE DW_TRANSPORTATION/EQUIPMENT/NFI_TRACTOR_SNAPSHOT_DAILY
SUM
NFI_TRACTOR_SNAPSHOT_DAILY.VWFACTTRACTORSNAPSHOTDAILY.TRACTOR_DAILYDISPATCHCOUNT
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROStar';
END
TABLE FILE NFI_TRACTOR_SNAPSHOT_DAILY
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROStar';
END
11.05.33 BT (FOC2590) AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
11.05.33 BT (FOC2565) THE OBJECT TRACTOR_DAILYDISPATCHCOUNT OF SUM CANNOT BE CONVERTED TO SQL
11.05.33 BT (FOC2605) ACTUAL MUST BE COMPATIBLE WITH USAGE FORMAT FOR P-TYPE FIELDS
11.05.33 AE SELECT
11.05.33 AE T1."Tractor_Key",
11.05.33 AE T1."Tractor_DailyDispatchCount",
11.05.33 AE T4."Tractor_Key",
11.05.33 AE T4."Tractor_Model"
11.05.33 AE FROM
11.05.33 AE dbo.vwFactTractorSnapshotDaily T1,
11.05.33 AE dbo.vwDimTractor T4
11.05.33 AE WHERE
11.05.33 AE (T4."Tractor_Key" = T1."Tractor_Key" ) AND
11.05.33 AE (T4."Tractor_Key" > 0) AND
11.05.33 AE (T4."Tractor_Model" = 'PROSTAR')
11.05.33 AE ORDER BY
11.05.33 AE T4."Tractor_Model";
0 NUMBER OF RECORDS IN TABLE= 32320 LINES= 1
0 HOLDING HTML FILE ON PC DISK ...
11.05.33 BT (FOC2590) AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
11.05.33 BT (FOC2565) THE OBJECT TRACTOR_DAILYDISPATCHCOUNT OF SUM CANNOT BE CONVERTED TO SQL
11.05.33 BT (FOC2605) ACTUAL MUST BE COMPATIBLE WITH USAGE FORMAT FOR P-TYPE FIELDS
11.05.33 AE SELECT
11.05.33 AE T1."Tractor_Key",
11.05.33 AE T1."Tractor_DailyDispatchCount",
11.05.33 AE T4."Tractor_Key",
11.05.33 AE T4."Tractor_Model"
11.05.33 AE FROM
11.05.33 AE dbo.vwFactTractorSnapshotDaily T1,
11.05.33 AE dbo.vwDimTractor T4
11.05.33 AE WHERE
11.05.33 AE (T4."Tractor_Key" = T1."Tractor_Key" ) AND
11.05.33 AE (T4."Tractor_Key" > 0) AND
11.05.33 AE (T4."Tractor_Model" = 'PROStar')
11.05.33 AE ORDER BY
11.05.33 AE T4."Tractor_Model";
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
0 HOLDING HTML FILE ON PC DISK ...
AGGREGATION DONE ...
11.05.34 AE SELECT
11.05.34 AE T4."Tractor_Model",
11.05.34 AE MAX(T4."Tractor_Model" )
11.05.34 AE FROM
11.05.34 AE dbo.vwDimTractor T4
11.05.34 AE WHERE
11.05.34 AE (T4."Tractor_Model" = 'PROStar')
11.05.34 AE GROUP BY
11.05.34 AE T4."Tractor_Model"
11.05.34 AE ORDER BY
11.05.34 AE T4."Tractor_Model";
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
0 HOLDING HTML FILE ON PC DISK ...

This message has been edited. Last edited by: David M,


WebFOCUS 8.1.05M, 8.2.02M
Windows, All Outputs
 
Posts: 34 | Location: Southern New Jersey | Registered: January 24, 2017Report This Post
Silver Member
posted Hide Post
I found the answer posted by Frances Mariani back in 2014. I am using the following SET command
SET COLLATION=SRV_CI

He references the document Creating Reports With WebFOCUS Language Release 8.0 Version 08 > Sorting Tabular Reports > Controlling Collation Sequence

Thanks Frances


WebFOCUS 8.1.05M, 8.2.02M
Windows, All Outputs
 
Posts: 34 | Location: Southern New Jersey | Registered: January 24, 2017Report This Post
Expert
posted Hide Post
David, it's francIs Smiler

Meanwhile, I'm glad the referenced documentation helped. I would look into why you get this error:


11.05.33 BT (FOC2565) THE OBJECT TRACTOR_DAILYDISPATCHCOUNT OF SUM CANNOT BE CONVERTED TO SQL
11.05.33 BT (FOC2605) ACTUAL MUST BE COMPATIBLE WITH USAGE FORMAT FOR P-TYPE FIELDS


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
Silver Member
posted Hide Post
Francis, first sorry for the typo on your name. Secondly thanks for the heads up on the warning message. My synonym shows that column to be a Decimal Packed (actual). To not show the decimals I had changed the usage to Integer. To get rid of the warning I changed the usage back to Decimal with a length of 8 and no decimals. So lesson learned, thanks.

David


WebFOCUS 8.1.05M, 8.2.02M
Windows, All Outputs
 
Posts: 34 | Location: Southern New Jersey | Registered: January 24, 2017Report 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     [SOLVED]CASE Sensitive

Copyright © 1996-2020 Information Builders