All Forums General
26 Jul 2013
rollback in teradata

how to rollback data in ansii as well btet modes  in teradata.can u please suggest me on this
Thanks,
P.Deepthi

tomnolan 594 posts Joined 01/08
26 Jul 2013

If you are developing a Java application that uses the Teradata JDBC Driver, and you have auto-commit turned off with Connection.setAutoCommit(false), then you can rollback the current transaction by calling Connection.rollback(), which works in either ANSI or TERA transaction mode.
 
If you are using BTEQ, the ROLLBACK command will roll back the current transaction in either ANSI or BTET mode.

You must sign in to leave a comment.