How can create a temporary table for all the sessions

jchidiac Nov 11, 2014 6:12 AM

Hi,

I'm using Teiid Embedded

i need to create a Temporary table and insert few records and use later

this temporary table should be use for all the sessions.

i tried with Local and Global temporary tables but the Data is related to the Session.

any help ?

1. Re: How can create a temporary table for all the sessions

shawkins Nov 11, 2014 8:06 AM (in response to jchidiac)

> any help ?

Both global and local temporary tables have their data as session scoped. Either you need to ensure it is reused within the session or introduce a new source table which would be accessible in all sessions.
Actions
2. Re: How can create a temporary table for all the sessions

jchidiac Nov 11, 2014 8:17 AM (in response to shawkins)

if i don't want to create a physically table on the DataBase
how can i introduce a new source table ?
Actions
3. Re: How can create a temporary table for all the sessions

shawkins Nov 11, 2014 8:55 AM (in response to jchidiac)

Unfortunately you'll have to resort to using an external source and add a corresponding metadata entry at design time (or via dynamic vdb import) or bring it into scope temporarily with create foreign temp table. Either way it does require a database or other source system.
Actions