Teradata Error 3706 Expected Global Temporary

7 views

Skip to first unread message

Roshelle Ravenel

unread,

Jan 25, 2024, 4:12:30 PM1/25/24

to nialibliolang

In Teradata I want to create a global temporary table and then reference this global table in other queries. I don't want to create a volatile table as I am using Teradata through another front-end and that front-end has to be able to tell whether the temporary table exists, hence volatile tables are not an option as it does not exist in the data dictionary.

Teradata Error 3706 Expected Global Temporary

Download ———>>> https://t.co/4ns9qLd5x2

A global temporary table is really nothing but a definition of a table. When a user accesses that table, it is materialized for that user only. If another user accesses the table, another instance, completely separate from the other, is materialized. If your first statement accessing the temp table is anything other than an insert (such as your select *), it will have no rows.