Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — 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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.