Standalone UPDATE in TPT

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.

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 !

Senior Apprentice

Re: Standalone UPDATE in TPT

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




Ward Analytics Ltd - information in motion