Standalone UPDATE in TPT

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Enthusiast

Standalone UPDATE in TPT

Hello ALL,

 

Does anybody knows how to execute an UPDATE statement in TPT. I tried with STREAM Operator, but getting error like User Doen not have Create MACRO Access.

 

Also tried with TPT UPDATE Operator, but its giving an error as  invalid UPDATE statement  as it does not depends on producer operator.

 

ANy suggestions.

 

Thanks !

1 REPLY
Senior Apprentice

Re: Standalone UPDATE in TPT

Use the DDL Operator. It is meant for statements that do not return answer sets.

 

Dave

 

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com