Re: Posting from the Informix-list

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). June -- june_t@hotmail.com Grounded in Palo Alto, living on Cafe Mocha