Re: TEMP Tables

Shew Leong wrote: > > Hi, > > Is there a limit to the number of temp tables you can create? > > My stored proc creates 5 but Informix errors out with error -131 - basically > ran out of space. > > Stats - Solaris 2.6 - Informix 7.2.3 No no limit, however, temp tables not created with the 'WITH NO LOG' option are created in the root dbspace rather than in any temp dbspace. Since most installations have a small root dbspace I assume that you filled yours up. Add the missing clause to the temp table creation statements (or replace the INTO TEMP clause with an explicit CREATE TEMP TABLE...WITH NO LOG and an INSERT INTO...SELECT) and all will be well. Art S. Kagel