Mload on global temporary tables
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Mload on global temporary tables Expand / Collapse
Author
Message
Posted 7/14/2006 2:32:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 12/28/2006 8:39:00 AM
Posts: 7, Visits: 1
How can we do an mload on gloabal temporary tables? Will the data last only through the mload session or the parent session?
Post #4614
Posted 7/14/2006 3:01:53 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 3:41:05 AM
Posts: 522, Visits: 264
You can't load a Global Temp Table using MLoad.

A temporary session is always session local and MLoad logs on 2 SQL session for control and several MLoad sessions.

But why do you even think about loading a temp table?

Dieter
Post #4616
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 3:49am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 7 queries. Compression Disabled.