Re: NewEra & Temp Tables

Posted in 1997

Art S. Kagel — Fri, 10 Oct 1997 10:04:01 -0400 — source: Informix-list mailing list archive (1991-1998)

Ttgchicago wrote: > > Hey all - > > Ive got some NE programs which create temp tables using the folloing 4GL > syntax: > > select field1, field2 from tablename where key_field = "KEY" > into temp temptablename with no log> > The programs compile just fine and run, but the temp tables are never created. Why do you think that the temp tables are not created? How did you try to verify this? Did you select from temptablename in the same program and get an SQL error -206, ISAM -111 or did you get 100 (NOT FOUND)? Or did you try to locate the table from another process? Or by looking in systables? Temp tables are not recorded in systables nor are they visible from other application sessions. Art S. Kagel