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     How to lock .FOC from MODIFY

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to lock .FOC from MODIFY
 Login/Join
 
<leftcoastuser>
posted
How can we lock old .FOC data files so that they cannot be inadvertently updated with MODIFY? Running on W2K.
 
Report This Post
drew billingslea
Silver Member
posted Hide Post
you might try to change the Windows file attributes to Read Only for those files

or

Add a USE to EDASPROF for each of those files with READ to make Focus use them read only

hth,

drew
 
Posts: 46 | Location: San Francisco, California | Registered: April 14, 2003Report This Post
susannah
Expert
posted Hide Post
Best to read chapter 9 in the manual "describing data". Page 9-3 describes Data base security.
You can set up in the master all sorts of security options, including who has the right to Update.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Carol Dobson
Guru
posted Hide Post
I had mutiple user's updated our Focus databases that needed modify access. I added code to each process, when the Focus Databases get's opened I wtite "Y" or "N" to a flag file (like update.flg)

Then I coded a check in the other modify programs to read the flag file before update and display a message the file is being updated by another user. Of course, you have to unlock the file at the end of the update.

I know it's an old fashioned approach but it works and keeps you from getting corrupt databases.

Good Luck,
Carol
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
<chris>
posted
You can add a line to the ACX file which reads: WRITE=NO .
 
Report This Post
Carol Dobson
Guru
posted Hide Post
FOCUS Databases don't have Access File Descriptions!
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
<chris>
posted
Yikes... sorry about that. WRITE=NO can be used only in ACX files and FOCUS files do not have ACX files.

Sorry for ay confusion that may have caused.
 
Report This Post
David Briars
Master
posted Hide Post
Hi leftcoastuser,

I protect FOCUS databases from changes, by issuing the USE comand with the read parameter.

For example, in the z/OS environment:



DYNAM ALLOC DD CAR DS SYSID.FOCUS.CAR SHR REUSE
-RUN
USE
CAR READ
END

This will protect your file from updates via the FOCUS MODIFY command.

If you do not need operating system level security, this might be something to look at.

USE could be used in conjunction with the other techniques listed previously.

Regards,
Dave

This message has been edited. Last edited by: <Mabel>,
 
Posts: 822 | Registered: April 23, 2003Report 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     How to lock .FOC from MODIFY

Copyright © 1996-2020 Information Builders