Re: Posting from the Informix-list

In article <3642578D.40F88AF6@hotmail.com>, June Tong <june_t@hotmail.com> writes >Miguel Angel Zupo Aguirre wrote: > >> My aplication have an error in one module, after the process an couples >> prepareds cursors, >> execute various statements and select rows into temp tables, display >> the next message: >> >> Program stopped at "gtosmesp.4gl", line number >> 615.**************************** >> SQL statement error number -566. >> Cannot initiate sort. >> SYSTEM error number -116. >> ISAM error: cannot allocate memory.> >What versions of products are you using? What is your 4GL program doing >(specifically) at this point. Looks like you are trying to sort some data; >depending on what exactly it is doing and what version you are on, and >whether you are using a shared memory connection, I'd say try to reduce the >amount of data you are sorting, set DBTEMP to a directory with more free >space, or maybe increase your SHMBASE (this may be tricky, because not just >any value of SHMBASE will work -- you might try 0x0). > OPTCOMPIND=0 may help... >June >-- >june_t@hotmail.com >Grounded in Palo Alto, living on Cafe Mocha > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care