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     APP HOLDMETA and APP HOLDDATA

Read-Only Read-Only Topic
Go
Search
Notify
Tools
APP HOLDMETA and APP HOLDDATA
 Login/Join
 
Francis Mariani
Expert
posted
quote:
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?
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Tony A
Expert
posted Hide Post
Francis,

Don't forget the new APP FILEDEF ddname DISK app/filename.extn to go with all the other APP commands.
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Francis Mariani
Expert
posted Hide Post
Tony,

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.

Thanks.
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Piipster
Guru
posted Hide Post
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, 2003Report This Post
dwf
Platinum Member
posted Hide Post
Francis,

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, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
dwf,

Thanks for the info.
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
Piipster,

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?

Thanks.
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Tony A
Expert
posted Hide Post
Francis,

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 Wink
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 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     APP HOLDMETA and APP HOLDDATA

Copyright © 1996-2020 Information Builders