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] DBMS SQL Generator Default Behavior Change HEADS UP

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] DBMS SQL Generator Default Behavior Change HEADS UP
 Login/Join
 
JohnG
Member
posted
My client is currently on WF7.7.02 and I've noticed a new default behavior for many of the relational database data adapters including all the major REBMS players.

I've done numerous searches through techsupport and there are other no public references to this issue, the impact this change has on read and/or write behavior.

Might sound like a really silly question, "Is there a reason for wanting trailing spaces EVER?"

From the "Adapter Administration for UNIX, Windows, OpenVMS, i5/OS, and z/OS Version 7 Release 7.02"

DN4501040.1110 Just released version!

Trailing Blanks in SQL Expressions
The new SQL Expression generator in the TABLE Adapter by default preserves literal contents, including trailing blanks in string literals and the fractional part and exponential notation in numeric literals. This allows greater control over the generated SQL.
In some rare cases when trailing blanks are not needed, the following syntax

ENGINE SQLMSS SET TRIM_LITERALS ON

is available to ensure backward compatibility.

Any comments on this issue is appreciated.

Thanks,

This message has been edited. Last edited by: Kerry,


John G
WF7.7.02, Win2008x64, MRE, ReportCaster, Maintain
 
Posts: 8 | Registered: January 05, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
John, I agree, I cannot think of a reason to preserve trailing spaces, ever.


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
Rob Bowen
Member
posted Hide Post
I did have one situation a few years ago where I was trying to select values from an Oracle DB which had a char(3) field. The values that I was looking for only contained two characters and required the trailing space to get the data back, but WF was stripping the trailing blank from the where clause before sending to Oracle to be processed.

To work around the issue, the dba change the field from character to variable character to resolve the issue.

Is this the behavior that your reffering to?


WebFOCUS 8.1.04; SQL Server 2012; Windows 7; Windows Server 2012 R2;
 
Posts: 26 | Registered: November 21, 2005Report This Post
JohnG
Member
posted Hide Post
Rob,

I opened a case on this topic to gather more information from IBI on how this feature changes behavior. I will publish their position on this change when I hear back on this issue.

Your note does describe why a trailing space would be needed in a WebFOCUS FEX, though other techniques could be used to bypass this default behavior.

The SQL world handles trailing spaces much more elegantly, duly noting each RDBMS can handle this situation differently.

Thank you for posting your experience!

Sincerely,


John G
WF7.7.02, Win2008x64, MRE, ReportCaster, Maintain
 
Posts: 8 | Registered: January 05, 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] DBMS SQL Generator Default Behavior Change HEADS UP

Copyright © 1996-2020 Information Builders