Focal Point
[SOLVED] max length of a focus table

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

September 13, 2010, 10:22 PM
Don Robison
[SOLVED] max length of a focus table
Is there a max length of a focus table?

This message has been edited. Last edited by: Kerry,


Version 7.17
September 13, 2010, 10:41 PM
Waz
What do you mean by length ?

Number of fields ?

Size of the file ?

Size of the record ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

September 14, 2010, 03:42 AM
GamP
Or maybe length of the file name? (66 characters)


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
September 14, 2010, 07:46 AM
Don Robison
I have had to expand a record length of a focus file. It has know gone over the 4000 byte threshold is there away to increase this size?


Version 7.17
September 14, 2010, 08:01 AM
Alan B
Is this using ON TABLE HOLD FORMAT FOCUS?

If so, an upgrade to 7.6.2 will give respite, or try and get multiple segment structure using multi-verb requests.

FOCUS files have a maximum segment length of 3962, XFOCUS 16256 (I think).

If it is not a HOLD, just split the segment with unique segments.


Alan.
WF 7.705/8.007
September 14, 2010, 09:04 AM
FrankDutch
If it is a focus database the max size is about 2 gig




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

September 14, 2010, 05:37 PM
Waz
Are you using FORMAT FOCUS ?

As Alan says, add some segements to the file.

How are you creating the FOCUS FILE


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code