Multiple temp tables

>When I make a temp table using "WITH NO LOG", it appears that multiple >tables are made for that one temp table (multiple entries in systabnames). >Trying it on two different systems, it appears the number of tables it >makes is the same as the number of dbspaces in DBSPACETEMP. This does not >happen with logging (only 1 table made). Has anyone else noticed this? >Is there a reason that this happens? > Thanks, > Paul When you create a temp table with no log, Informix will create the temp table across your temp dbspaces listed in DBSPACETEMP. That would explain the multiple entries in systabnames. Hope this helps John Carlson Informix DBA WH Smith, Inc. -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet