Multiple temp tables

Posted in 1997

Paul Drake — 15 May 1997 04:40:46 GMT — source: Informix-list mailing list archive (1991-1998)

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