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] Max number of & variables

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Max number of & variables
 Login/Join
 
TonyB
Member
posted
Hello,

we are using WebFocus some 4 years now. Al our reports are built by coding (we don't use the WF Development Tool).

Until now we only had reports in Dutch (labels etc).

The question has risen how to make the reports multi-language.

The easiest way would be to introduce a global variable &&LANG and use this in decode statements to set &variables for all the different labels.

Something like:

-SET &LABEL1 = DECODE &&LANG ( DL 'Verursacher'
- EN 'Cause,problem'
- NL 'Veroorzaker' ) ;

All the items would in a central include-file.

Question: how many & variables can we use (WF 7.6.2) in one session?

I've read a topic on this forum, but it is inconclusive.
Somebody says that there is no limit; an other one has used 100K vars (gives bad performance)


If we need thousands, is that possible?


Maybe there is a different way to make our reports mult-language?


Antony

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


WebFocus 8.0.3
Windows 7 Prof
Oracle 11.2.0.3
Output PDF and Excel
 
Posts: 19 | Location: Netherlands | Registered: April 21, 2008Report This Post
Waz
Expert
posted Hide Post
There is no definitive number, it relies on your environment and session.

I have had thousands, it also depends on the size of the contents of the variables.


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
GamP
Virtuoso
posted Hide Post
In the new features overview for release 761 it is clearly stated:
quote:
An unlimited number of Dialogue Manager variables can be used in a procedure.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Baillecl
Platinum Member
posted Hide Post
I expect Canadian People to give good advice about International Messages. (A Lasry, if you hear me ...)
I am not fond of so many Decodes, and, as a Colbertist Centraliser, prefer a Central Data Base of Messages + a very performant tool to access those Messages.
But, as an old craftsman, I perhaps miss new efficient tools and keep clutched to old ideas.


Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
 
Posts: 134 | Registered: November 06, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
TonyB,

There are many ways to do this.

The easiest would probably be to decode a Dialogue Manager Include statement:

-DEFAULT &&LANG = 'FR';

-SET &INC1 = '-INCLUDE INC_LABEL_' || &⟨

&INC1.EVAL

TABLE FILE CAR
SUM SALES AS '&LABEL1'
BY COUNTRY AS '&LABEL2'
END
-RUN


inc_label_en.fex:
-SET &LABEL1 = 'Country';
-SET &LABEL2 = 'Sales';

inc_label_fr.fex:
-SET &LABEL1 = 'Pays';
-SET &LABEL2 = 'Ventes';


Claude's idea of storing the language-based text in a table is another idea...


Claude, Albert can be reached via Skype.


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
Danny-SRL
Virtuoso
posted Hide Post
Antony,

We have the same problem here in Israel, compounded with the fact that Hebrew is written right-to-left.

When we have to develop a multi-language application, we use only &variables for everything: titles, texts, headings etc. Then our application is developed using our in-house system where all the the forms and all the objects are stored in a central database in many languages. Similarly, we store the values of the &variables in the same central database, also in many languages.

When the application is run, the language is set by ONE variable and automatically all the &variables, forms and objects are given the appropriate values from the central repository.

Adding an extra language becomes very simple and the procedures are invariant.


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
dhagen
Virtuoso
posted Hide Post
If you are using 76x, then multi-language can be applied at the master level. Use the meta-data for all of the column title language values. If you place your defines and computes in the master as well, then you could use the same method. That would save you a lot of trouble.

The only thing you should have to use the ampher variables for is report based defines and computes, and page headings/footings.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report 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] Max number of & variables

Copyright © 1996-2020 Information Builders