Focal Point
[CLOSED] MFD Size

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

February 13, 2012, 09:33 AM
wf_devloper
[CLOSED] MFD Size
Hi,
Is there a limitation on the size or the number of columns that can be provided in the MFD?
we have a Oracle table containing more than 700 columns and does creating MFD work on this table?

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


WF 7.7.05 on Linux
HTML, PDF, EXCEL
February 13, 2012, 02:09 PM
Waz
Can't see why not.

Have you tried yet ?

You probably won't be able to report on all the columns at once though.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 17, 2012, 10:59 AM
wf_devloper
Hi Waz,
I tried and it error out. I think the problem is the total field size is more than 32K and the MFD can support only up to 32K. not sure if there is a work around.


WF 7.7.05 on Linux
HTML, PDF, EXCEL
February 17, 2012, 11:24 AM
Håkan
Have you tried /* NOCOLS */ ?

Makes WF to get the column names dynamically

Håkan


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
February 19, 2012, 03:58 PM
Waz
How many of these columns do you need ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!