rollback in teradata

General

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

1 REPLY
Teradata Employee

Re: rollback in teradata

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.