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     Variable MFD file name

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Variable MFD file name
 Login/Join
 
gregson06
Platinum Member
posted
Okay, here's a real whopper. A user is requesting that they be able to specify the name of the data file that the MFD definition is pointing to. Is this even possible to pass a variable that is the filename? I would imagine that it would be something like:

DATASET='/pathname/&filename'

Is this even possible or is it just crazy-talk?

Thanks!

Oh yeah, running WebFOCUS 5.3

This message has been edited. Last edited by: gregson06,
 
Posts: 87 | Registered: August 03, 2006Report This Post
Leah
Virtuoso
posted Hide Post
We do it all the time in our 'production environment' Of course it's not the whole MFD name but part of it.

Example

RTRTTBL_UNO_®ION

REGION is passed as a parameter. We have three versions, PROD, TEST and QUAL. Of course when developing the report or what ever have to use a -SET command for the parameter so you can do what you need. Of course with the way DEV stuio tags everything you may have some issues there.

Where the html shows the registered trade mark symbol it is actually the characters '&' 'R' 'E' and 'G' in other words the word REGION proceeded by the '&'.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
gregson06
Platinum Member
posted Hide Post
So how would the variable name be referenced in the MFD definition?

I would think that it would be like:

DATASET=&FILENAME

but I've never passed a variable to an MFD, I think that's where I get stuck in this procedure.
 
Posts: 87 | Registered: August 03, 2006Report This Post
Darin Lee
Virtuoso
posted Hide Post
You wouldn't be able do insert the &FILENAME in the master file. However, you can FILEDEF (or DYNAM ALLOC or whatever is appropriate for you platform). You would need to remove the DATASET specification from teh MFD. This is how we dynamically determine the data set that will be accessed.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
gregson06
Platinum Member
posted Hide Post
Is there an example, perhaps, that can be pointed out on this? I am not very familiar with FILEDEFs in this fashion. I sometimes use them to create temporary hold files, but beyond that they're relatively new to me.
 
Posts: 87 | Registered: August 03, 2006Report This Post
gregson06
Platinum Member
posted Hide Post
Nevermind, figured it out, but that basically did it thanks! I had to define it on the FILEDEF statement, of course I can use the & symbol to specify the file there.

Thanks again!
 
Posts: 87 | Registered: August 03, 2006Report This Post
jgelona
Master
posted Hide Post
I asked for this a while back as a new feature request. Not so much for the file name as the path, for example,

DATASET=&PATH&FILENAME

They (IBI) said that since you can accomplish the same thing with USE and FILEDEF and because it would radically change the way the .mas files are processed, they declined.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Edan
Member
posted Hide Post
My favorite feature in WebFOCUS is being able to use dialog manager. It is a shame that Masters can't have embeded dialog manager.

The way I envision dialog manager working with masters would be similoar to an -INCLUDE. Whenever the Master is initially invoked or at a CHECK FILE ... statement, the Master would be parsed. The normal lines in a master would be have like regular WebFOCUS statements and be put on the focstack. All dialog manager variables and statements would work to generate the focstack.
 
Posts: 8 | Location: New York | Registered: March 28, 2005Report This Post
John_Edwards
Virtuoso
posted Hide Post
How often does the update need to occur, and is it user-specific?

If I was to go after this critter I would look into using an external tool to rewrite the master file -- a scripting tool or the like, depending on the OS. Since only one small bit is changing it would be a simple concatenation of three pieces.

But! the change would apply globally since the MFD is in a public space. If it needs to change dynamically for each user, and on each run, trouble. If it needs to change overnight or when a new file arrives, it's not so bad.

I-Way may even be able to create the file for you if you want to stay in the IB toolset. The above caveats still apply though.

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 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     Variable MFD file name

Copyright © 1996-2020 Information Builders