Volatile table across Sessions

Database
Fan

Volatile table across Sessions

Is there a way we can access volatile table across sessions.

May be by creating child session in TPT or anything else.

2 REPLIES
Teradata Employee

Re: Volatile table across Sessions

Volatile and global temp table instances are strictly local to the session in which they are created and may not be accessed in any way from another session.
Fan

Re: Volatile table across Sessions

As I was going through the logs present in DBC I see someone created volatile table in session1 and using that in session2 with same user, while there was no create statement in session2.

Those session are from some ETL tool like Ab initio.

How can this be possible.