[SOLVED] Need help in creating FOCUS file more than 2GB

Focal Point

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

March 30, 2017, 01:14 AM

Sureshkuamr Murugesan

[SOLVED] Need help in creating FOCUS file more than 2GB

Hi All,

Need help in creating FOCUS file more than 2GB (Read somewhere the maximum size is 2GB). Is there any way to break the large files into multiple focus files and how can we merge in code.

Can we get a sample code for the same.

Regards,
Suresh

This message has been edited. Last edited by: Sureshkuamr Murugesan,

WebFOCUS 8.0.05 - BI Portal, Developer Studio, Dev/App Studio, Excel, PDF, Active Formats and HTML5, Adobe Flex Builder, VBA

March 30, 2017, 04:14 AM

Wep5622

You could just use a different format. I suggest XFOCUS. You can also store in an RDBMS of your choice.

You could try using FOCUS and use MORE to concatenate separate FOCUS files, but that's a lot of trouble that will probably gain you nothing compared to using XFOCUS instead.

WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :

March 30, 2017, 08:10 AM

Sureshkuamr Murugesan

Thanks Wep5622 for your suggestion.

We already implemented the XFOCUS instead of FOCUS in our report and it works fine now.

Regards,
Suresh

WebFOCUS 8.0.05 - BI Portal, Developer Studio, Dev/App Studio, Excel, PDF, Active Formats and HTML5, Adobe Flex Builder, VBA