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.
Carlson@WHSmith — — source: Informix-list mailing list archive (1991-1998)
Magnus Westling wrote:
>
> Does anyone know the syntax for creating temptables in informix. I know how it works in sybase?
>
> /Robert
try
SELECT col1, col2, col3
FROM tab_a
WHERE {wherever}
into temp (temptable name)
John Carlson
Informix DBA
WH Smith, Inc.
Your privacy choices
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.