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] Can the distribution file in RC have a variable for the path

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Can the distribution file in RC have a variable for the path
 Login/Join
 
Gold member
posted
We are on UNIX and try to use variables whenever possible. A ReportCaster schedule is burst using a distribution file on UNIX. I would like to use a variable for the path to the distribution so we don't need to hard-code the path in each schedule. I tried setting a global WF variable &&WF_ITNAS and I tried setting a UNIX variable with 'export WF_ITNAS=. Neither one worked. It does not look like RC resolves the variables. Does anyone have an idea how to use a variable for the path to find the distribution file?

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


WebFOCUS 7.7.05M, gen 144, Windows 2008 Server R2 64-bit, Tomcat 6.0.33, IIS 7.0, SQL Server, Excel 2013, PDF, HTML, FOCUS files.
 
Posts: 88 | Location: Seattle | Registered: March 29, 2007Report This Post
Gold member
posted Hide Post
My signature file was old. We are one WF/RC 7.6.6. Thanks.


WebFOCUS 7.7.05M, gen 144, Windows 2008 Server R2 64-bit, Tomcat 6.0.33, IIS 7.0, SQL Server, Excel 2013, PDF, HTML, FOCUS files.
 
Posts: 88 | Location: Seattle | Registered: March 29, 2007Report This Post
Expert
posted Hide Post
You can use a DYNAMIC distribution list(read up on that), rather than a fixed one. a Dyn list is a fex, makes an xml output.
but you're going to have to pass something to the list fex to determine the path, right?... and that distribution fex doesn't take a parameter from the schedule ... at least i've never thought of just concatenating an &var to the end of the pth/fexname in the distribution page.
hmmm.
what's 'Control-M' ?




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Master
posted Hide Post
You can also use UNIX FTP commands in your fex. You will get a "No Report to Distribute" from ReportCaster if you do this.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Gold member
posted Hide Post
The variable I want is not the name but the environment. For instance, the path to where the output is written on our Prod server is /dwh/prd/app/tcs. On our Test server it is /dwh/tst/app/tcs. I would like the environment (prd, tst, dev) to be a variable so that I could set the value in 1 place on each server and not have to change it for each schedule. The output filename is static. We are not allowed to FTP to internal servers.


WebFOCUS 7.7.05M, gen 144, Windows 2008 Server R2 64-bit, Tomcat 6.0.33, IIS 7.0, SQL Server, Excel 2013, PDF, HTML, FOCUS files.
 
Posts: 88 | Location: Seattle | Registered: March 29, 2007Report This Post
Virtuoso
posted Hide Post
That sounds like a good idea for a new feature request. Bad news is that the product doesn't currently allow for that. The dynamic distribution list that Susannah mentions allows you to specify different servers, but the destination directory does not take a variable, nor is it acessible by a dynamic distribution list. It is either hard coded, or takes the default directory of the user name being used in the FTP process. Probably your only hope is to have duplicate jobs for Test and Prod, and either using different user id's (which have their default directory set to the desired location) or hard-coding the desired location (which seems like it would be harder to manage.)

Manually performing the FTP process, as Pat suggests, is probably the only other option, for now.


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
Expert
posted Hide Post
Bob
do you have 3 environments?... 3 servers, with 3 separate reportcasters running?
if so, do this:
1) in the edasprof, create a variable
-SET &&basefilepath = '/dwh/prd/apps/tcs';
where the prd bit changes for each server.
2) in your caster job, use a fex to create the distribution list (so, in setting upthe job, select dynamic distributionlist, and point to the fex)
and the fex looks like this:
FILEDEF MYLIST DISK &&basefilepath|/mylist.txt
TABLE FILE MYLIST
PRINT emailaddress AS VALUE
-* BY userid AS DEST
ON TABLE PCHOLD FORMAT XML
END
... the BY userid AS DEST is only if you're bursting
.... and for extra credit, see if you can figure out how you would create carbon copies for a burst list...




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Gold member
posted Hide Post
Thanks Susannah. I'll investigate that. If successful, I'll add a posting.


WebFOCUS 7.7.05M, gen 144, Windows 2008 Server R2 64-bit, Tomcat 6.0.33, IIS 7.0, SQL Server, Excel 2013, PDF, HTML, FOCUS files.
 
Posts: 88 | Location: Seattle | Registered: March 29, 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     [CLOSED] Can the distribution file in RC have a variable for the path

Copyright © 1996-2020 Information Builders