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.
APP HOLDMETA app Designates app as the location for Master Files and Access Files created with the HOLD command.
APP HOLDDATA app Designates app as the location for data files created with the HOLD command.
I am using these two commands to make it easy to create HOLD files on one server, then move and read them on another server.
Instead of using FILEDEF commands for each of the HOLD files being created, the APP HOLDMETA and APP HOLDDATA commands set the location of the data files and Masters - when creating the HOLD files.
Unfortunately, these commands do not set the location of the data files when reading the HOLD files. This seems to be quite inconsistent. It appears I have to issue a FILEDEF command for each of the HOLD files.
Am I missing something or do I have to have FILEDEF's when reading but do not require them when creating?
Thanks for the APP FILEDEF details. Unfortunately, it has to be applied for each file being read while APP HOLDMETA and APP HOLDDATA only need to be set once. It seems a bit inconsistent to me.
You, of course, don't need to specify the location if you are creating and reading the file as part of the same process. If you are reading a file that has been created previously, it may or may not have been created via a HOLD file command and the file extension can be anything ... .ftm, .dat, .txt, etc. That would be hard to filedef automatically.
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003
If you hold the file in FOCUS format, then you won't need to filedef, as long as the file and the master are in your path. And you can use APP PATH or APP APPENDPATH (and maybe APP MAP) to change that path.
Example:
APP HOLDMETA TOOLS APP HOLDDATA TOOLS
TABLE FILE RACCT PRINT ACCT_NBR WHERE RECORDLIMIT EQ 10 ON TABLE HOLD AS DACCT FORMAT FOCUS END
As long as TOOLS is in the path of subquent focexecs, I can report on DACCT without a FILEDEF.
Posts: 135 | Location: Portland, OR | Registered: March 23, 2005
The APP HOLDDATA app command must exist for some reason.
If you don't have any FILEDEF statements for the HOLD files being created, the file extension is set to ftm. The APP HOLDDATA app command puts the HOLD files in the specified app directory.
Then, in another request, you would like to access the HOLD files. Performing the APP HOLDDATA app command should be enough to find the files, since ftm should be assumed, unless specfic FILEDEF's were performed.
Otherwise what's the use of the APP HOLDDATA app command?
APP HOLDDATA can be used for ON TABLE SAVE as well as 'normal' HOLD files. Useful for when you have a set file format that you keep with your other synonyms. Agreed, you have still to issue the FILEDEF but then that's always been the situation in the majority of held files, except for FOCUS format files.
Another use, I suppose, would be for when a datafile needs to be kept for FTP etc. to be read by another program in another language.
Annoying, I know, but we're used to that
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004