Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Hello. In my short time using WebFOCUS, I have created both...

Todd Van Valkenburg

Recommended Posts

You can concatenate multiple (identical) FOCUS files with the USE command which allows you to partition your data and only report off of the .foc files you want. We used to use this very effectively in historical reporting where each years data was in a separate .foc file and we archived old ones to keep reports running more efficiently. You can have multi-segment foc files. Not sure if this is a big deal now a days. You already mentioned Indexing which is another advantage.
Link to comment
Share on other sites

NYCBabaks comments are very valid. Most hold files are pretty small in size so you wont find a big performance difference but if you anticipate the file file will be large then using a FOCUS database with indexes will definitely improve the performance of the subsequent reports. When you create large hold files I recommend using Run Deferred or ReportCaster so you dont tie up your browser session waiting for a long time. Also there are field name length restrictions when indexing a FOCUS database. I think the field name cant be longer than 16 so you may have to turn ASNAMES ON and make your field title accordingly.
Link to comment
Share on other sites

Hello. In my short time using WebFOCUS, I have created both FOCUS and BINARY permanent hold files for later use by other reports and html pages. Both formats seemed to work fine and I only saw a difference in the segment name when looking at the mas file and so I just use BINARY. But I was wondering what considerations I should give before using one type versus another and perhaps I am missing something. Any performance benefits Any pro/cons that you have encountered The only thing that I read in an InfoAssist pdf was that FOCUS hold files can have an index which I have not yet explored.

Thank you for your insight.


Link to comment
Share on other sites

  • 3 months later...
  • 4 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...