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     Documentation requiring revision in 76

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Documentation requiring revision in 76
 Login/Join
 
hammo1j
Master
posted
Hi I am creating this category to list specific documentation problems that need to be addressed in the latest manual.

NB The quality of wf docs is good and I find the docs team usually very responsive so this is only to point out needed corrections.


Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
hammo1j
Master
posted Hide Post
Creating reports with wf language - 5 Selecting Records for Your Report - Usage Notes for Reading Values from a File.

"For IF the total of all files can be up to 32767 literals including new line and other formatting characters. Lower limits apply to fixed sequential and other non relational data sources"

Should read

For IF field EQ (ddname) up to 32,767 items can be contained in the file refered to by ddname. This is regardless of the length of each item. WebFOCUS applies this limit to non relational sources (FOCUS,XFOCUS,sequential), but this limit may be reduced for relational sources. Here WebFOCUS translates the equality test against the literals in the file to an 'IN' phrase which is subject to the limits of the rdbms (Example Oracle 9.2 only allows 1000 values)

So the limit is much higher than you think!


This can be confirmed by putting
0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789
into C:\TEST.TXT 32767 times and confirming the program runs.

FILEDEF SAVE DISK C:\TEST.TXT 
DEFINE FILE CAR
BIGCOUNTRY/A100 = COUNTRY ;
END
TABLE FILE CAR
PRINT COUNTRY
IF BIGCOUNTRY EQ (SAVE)
END


Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
hammo1j
Master
posted Hide Post
TABLE and TABLEF syntax

1. TABLE does not show alternate view
2. TABLEF permits COMPUTE


Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
hammo1j
Master
posted Hide Post
Inconsistent layout of rc distribution file


Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
hammo1j
Master
posted Hide Post
15. Joining Data Sources

INNER is not the default join type since it depends of the setting of SET=ALL and UNIQUE or MULTIPLE.

ALL needs to be listed as an option for the cardinality of the JOIN.


Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
hammo1j
Master
posted Hide Post
God I am such a pedant!


Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report 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     Documentation requiring revision in 76

Copyright © 1996-2020 Information Builders