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     Dynam allocate for hold files

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Dynam allocate for hold files
 Login/Join
 
RB
Gold member
posted
Hi,

I wrote a report and saved it as

ON TABLE HOLD AS HOLD1

Now I want to use this hold1 file to write some other new reports.

Is it possible to do this in Webfocus MRE?
I am thinking of dynam allocating the HOLD1 file. But not sure how to do that.

Please help me with this.

Thanks
 
Posts: 76 | Registered: October 28, 2003Report This Post
<Grzegorz>
posted
HOLD is performed by the WF Reporting Server, so it does not matter if it is invoked from MRE or self-service application. To create report with HOLD from MRE you can use MRE console text editor.

There are plenty of possibilities to use HOLDed files. Look at the chapter 4. "Managing Matadata" in "iWay Server Administration ... Version 5 Release 2.3" manual. IBI TechSupport Link
You can also look at the following threads on the forum (there are interesting and useful techniques described):

  • deleting temp files
  • sorting the report by any column
  • appending multiple tables to HOLD files
  • Accessing a Hold File on reloading page
 
Report This Post
RB
Gold member
posted Hide Post
I am using MRE 4.3.5 version. So, not sure whether the methods explained will work for creating HOLD files.

Thank you.
 
Posts: 76 | Registered: October 28, 2003Report This Post
<Grzegorz>
posted
WebFOCUS Server Application Namespace - APP PATH is described in the "Summary of New Features Version 4 Release 3.1", so most of the techniques described, should work in 4.3.5 release.
You can also use the "old" EDAPATH and FILEDEF syntax, something like this (on Windows):


FILEDEF CARHLD DISK D:\ibi\apps\tests\carhld.ftm
TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE HOLD AS CARHLD
END

Now if you have D:\ibi\apps\tests in the EDAPATH (e.g. set up in the edasprof.prf), you can use the CARHLD for the other reports.


-* EDASPROF.PRF
-* ...
SET EDAPATH=+D:\ibi\apps\ggdemo; -
D:\ibi\apps\tests;
-* ...
If you need to delete the file, you can use the operating system command (if memory serves me, it should work in 4.3.5):


! del D:\ibi\tests\carhld.*
Hope this helps
Grzegorz

This message has been edited. Last edited by: <Mabel>,
 
Report 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     Dynam allocate for hold files

Copyright © 1996-2020 Information Builders