Re: Temporary questions

: If you check the free space in your tempdbspace before you create a temp : table and then afterwards, it should decrease. If it doesn't, you may have a : configuration discrepancy... No, it didn't decrease. What was really touched is rootdbs. But new information from Informix Technical Support says, that it should by so : > This is the behavior of Online 7.10.UD1 with a database with logging. > Explicit Temporary tables: > > CREATE TEMP TABLE same dbspace as database > CREATE TEMP TABLE WITH NO LOG same dbspace as database > SELECT INTO TEMP rootdbspace > SELECT INTO TEMP WITH NO LOG rootdbspace> > if DBSPACETEMP is set to a temporary dbspace: > > CREATE TEMP TABLE rootdbspace > CREATE TEMP TABLE WITH NO LOG DBSPACETEMP > SELECT INTO TEMP rootdbspace > SELECT INTO TEMP WITH NO LOG DBSPACETEMP Thank YOU all people for YOUR help. Excuse me for wasting Your time. Yours Rasto. -- Rastislav JANAC SOFTEC s. r. o. e-mail: rasto@softec.sk Kutuzovova 23 phone : 42-7-273805 ext.127 831 01 Bratislava fax : 42-7-272537 Slovakia