Focal Point
FOCUS database created in WF can't be modified in Focus Six

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7341075952

November 30, 2007, 02:37 PM
Carol Dobson
FOCUS database created in WF can't be modified in Focus Six
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
November 30, 2007, 03:08 PM
Prarie
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
November 30, 2007, 04:16 PM
Carol Dobson
Thanks and for you it must be almost Miller time!



WebFOCUS 7.6.6/TomCat/Win2k3
December 04, 2007, 04:27 AM
GamP
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
December 04, 2007, 01:18 PM
KentO
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
December 04, 2007, 01:53 PM
Jim Morrow
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



December 05, 2007, 11:48 AM
KentO
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
December 07, 2007, 09:50 AM
Carol Dobson
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