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     FOCUS database created in WF can't be modified in Focus Six

Read-Only Read-Only Topic
Go
Search
Notify
Tools
FOCUS database created in WF can't be modified in Focus Six
 Login/Join
 
Carol Dobson
Guru
posted
I have a Focus database created in WebFOCUS 5.2.8 that I wanted to bring back to FOCUS Six for Windows to MODIFY again in a batch cycle - but it can't be done. I thinking they are not portable across platforms. I seem to remember this is a problem. You can read the table, just not modify. Anyone know a workaround?

Reason I tried moving it to WebFOCUS is the previous TABLE request was blowing out FOCSORT because of the volume of data. Process went from 30 mintutes to 30 seconds. I should have known better.

My workaround was to use a DOS SORT to sort the file and then TABLEF to read it in and I had to eliminate the WebFOCUS process all together. Frowner

Have a good weekend everyone!



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Prarie
Virtuoso
posted Hide Post
I have a Focus database created in WebFOCUS 5.2.8 that I wanted to bring back to FOCUS Six for Windows

Oh Carol...I'm so sorry.. Wink


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Carol Dobson
Guru
posted Hide Post
Thanks and for you it must be almost Miller time!



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
GamP
Virtuoso
posted Hide Post
Carol,
It's not possible to acces a WF created databse by focus for windows.
Reason is that WF creates a database with a max size of 1 GB, whereas Focus for windows is still on 256 MB. The internal pointer structure has slightly changed in WebFocus, allowing for this growth of the DB.
This means that there is no downwards compatibility. The 256MB files are still accessible in Webfocus though, so there is upward compatibility.
The best workarounds I can come up with is to rewrite your modify code to maintain in WebFocus or to dump the database to a flat file and re-create it in focus for windows...
Regards,


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
KentO
Gold member
posted Hide Post
I have copied WF 7.6.0 files to Focus Six and done a Focus Six Rebuild/Reorg on the files. Then I have been able to use the files in Focus Six programs.
Kent


Windows2003 Server, WebFOCUS 7.7.02 Developers Studio and MRE
 
Posts: 63 | Location: Ft. Wayne, IN | Registered: February 20, 2007Report This Post
Jim Morrow
Platinum Member
posted Hide Post
GamP’s post brought to mind the MVS

SET FOC2GIGDB=ON

The other setting is OFF which cause FOCUS to create the “old” smaller DB

When I try in a .fex under WebFocus 5.5.3 under Windows I get an error message

(FOC964) THIS SET OPTION ONLY ALLOWED IN FOCUS FOCPARM FILE: FOC2GIGDB

What if you do the create under FOCUS Six can you copy it back to WebFocus?


But, what if you do the create under FOCUS Six can you copy it back to WebFocus?


Jim Morrow
Web Focus 7.6.10 under Windows 2003
MVS 7.3.3



 
Posts: 129 | Registered: June 01, 2005Report This Post
KentO
Gold member
posted Hide Post
When I copy a file created under FOCUS 6 to WebFOCUS 7.6.0, I sometimes have to use the WF utility function "REBUILD" before the file can be used by WF. I don't have any trouble after the Rebuild is done.
Kent


Windows2003 Server, WebFOCUS 7.7.02 Developers Studio and MRE
 
Posts: 63 | Location: Ft. Wayne, IN | Registered: February 20, 2007Report This Post
Carol Dobson
Guru
posted Hide Post
KentoO - thank you for this information at least it makes sense now.

To my good friend Jim - I'm going to try to do the CREATE in FOCUS Six, and modify in WebFOCUS and see what happens. It's worth a try.
The DOS Sort thing took care of my immediate problem. Nice to see you at the Conference and hope you and your family have a nice holiday! Wink



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 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     FOCUS database created in WF can't be modified in Focus Six

Copyright © 1996-2020 Information Builders