Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     whadya do when the focsort gets over 2gig?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
whadya do when the focsort gets over 2gig?
 Login/Join
 
Expert
posted
eda -12 and red death.
any work around ideas?




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Expert
posted Hide Post
Hi Susannah,

Have you checked this one out yet?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Virtuoso
posted Hide Post
WOW. 1000 posts for Susannah...does she get a Prize? Thanks for all the help you have given. Smiler


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
isn't THAT interesting.
you rock, T.

Prarie, i'm sure over half of those posts have been thanks for help i've received from you and everyone else, and applause for help i didn't even know i needed. Smiler

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




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Expert
posted Hide Post
T, didn't work.
still bombs
my understanding of EXTSORT, which is probably apocryphal, is that EXTSORT gets called automatically when focus needs it.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Member
posted Hide Post
My understanding is that, on the mainframe, EXTSORT will invoke SYNCSORT or whatever sort is installed. I'm not aware of any external sort package natively part of Windows?
 
Posts: 21 | Location: South Africa | Registered: April 22, 2005Report This Post
Virtuoso
posted Hide Post
I second ruhan's comment. I thought EXTSORT was only available on mainframe.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Virtuoso
posted Hide Post
Several approaches to try, depending on your data source and the ordering requirement for the result.

a. Look for a way to use TABLEF (rather than TABLE); then there is no FOCSORT involvement. If your source is a database server, "optimize" the request so that the server does the grouping.

b. If the table request can be converted from single-verb to multiple-verb, with a cascade of sorting phrases, the overall size of the internal matrix (really an on-the-fly hierarchical Focus file) may be considerably less than when a single verb is used, so it may beat the 2gb limit.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Guru
posted Hide Post
quote:
ly



IB - Developer Center Forums FOCUS/WebFOCUS whadya do when the focsort gets over 2gig?


I have had success using TABLEF when reaching the 2gig limit.



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Expert
posted Hide Post
For those of you without TechSupprt access, the main content (excluding EXTSORT) in the link I gave above is -

SET AUTOTABLEF = ON
SET SAVEMATRIX = OFF

Using TABLEF as a default and avoiding the building of the internal matrix can considerably reduce the focsort requirements, as can reducing the number of BY phrases so that the internal 4 bytes required for each row for each BY field is reduced, thus reducing the total length of a single data row in the focsort.

e.g. If you have 12 BY phrases and you concatenate these fields into one and then sort by that, you could save 44 bytes per data row. If you have 1 million rows then that represents about 42 Mb(?).

If your data source is SQL then achieve all your collating and sorting of the output in your view or database definition so that you can just -

TABLEF FILE viewname (or SQLOUT)
PRINT *
ON TABLE HOLD AS whatever
END

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Member
posted Hide Post
I kludged a workaround in a similar situation by concatenating 3 or 4 BY fields into a single field.
 
Posts: 15 | Location: New York | Registered: April 02, 2004Report This Post
Expert
posted Hide Post
Thanks Robin,

It's great to have an actual example of one's ramblings!

The proof of the pudding .......

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Gold member
posted Hide Post
We've worked around this limit on solaris by "chunking" the data. It's a pain. Just enter "chunking" into the find box on this bulletin board to see what we went through.
-James


WF 7.1.6 moving to WF 7.7, Solaris 10, HTML,PDF,XL
 
Posts: 83 | Location: Dartmouth Hitchcock Medical Center | Registered: April 17, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     whadya do when the focsort gets over 2gig?

Copyright © 1996-2020 Information Builders