Archives of the TeradataForum
Message Posted: Fri, 01 Jul 2005 @ 10:10:27 GMT
| Subj: | | Re: How to rollback the insert statement in Teradata |
| |
| From: | | Dieter Noeth |
Sushant Paricharak wrote:
| | Is there any method or command to rollback or commit in teradata | |
If you run a session in Teradata mode then the default is autocommit after each statement, but you can override it with:
"begin transaction;" or "bt;"
dml statements
"end transaction;" or "et;" to commit
"rollback" or "abort" to rollback
If you run a session in ANSI mode then it's "commit" or "rollback"
But be aware of long running rollbacks, see the previous thread ;-)
Dieter
| 
