Re: Informix System constraints

Patrice, > We're currently developing software using Informix 4GL and FourGen CASE > tools on a 486 box running SCO Unix 3.2.2. > > Our application has become rather large (several thousand lines of 4GL > code) and we've encountered a problem that's got me stumped. > > 1) Informix error -4518: The 4GL program connot allocate any more space for > temporary string storage. > > This problem occurs after several passes through the program. I am not > using temporary string storage at the statement in which the error occured, > and I can't locate any temporary strings being used elsewhere. Is this > temporary string used by the system? I had a similar problem in 2.10.03L (Don't know what version you have). I was told by Informix person that works within AT&T that there are 2 things that can make this string space disappear. They are: 1) Having a case statement without an "otherwise". The reason was that some memory is released when a "case" condition is met. There does not have to be anything executed in the "otherwise". It just needs to exist. 2) Use "call function(argument) returning variable" instead of "let variable = function(argument)". For some unknown reason, Informix likes example one better. I had a report that would periodically crap out with message you got, and changing using the above rules made it more cooperative. I know it seems like black magic, but it worked for me! Hope that helps, EBD -- Elliot Dierksen "Is that a real poncho... I mean is that a Mexican poncho or is that a Sears poncho? Hmmm... no foolin'..." -- F. Zappa W) e.dierksen@att.com (407) 660-3377 H) elliot@alfred.UUCP (407) 290-9744