Can I rollback in ANSI mode without Transient Journel?
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home   
Search
    Guidelines    Member List
Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Teradata Discussion Forums » Teradata » Teradata Tools and Utilities » Can I rollback in ANSI mode without Transient...
This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Can I rollback in ANSI mode without Transient... Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
ravindrareddy
Posted 11/6/2009 2:59:57 PM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 11/6/2009 11:56:30 PM
Posts: 19, Visits: 37
Can I rollback in ANSI mode without Transient Journel?

I have a requirement to update a table...if the number of records which are updated is not matched with the intended number of records it should not commit to DB.

Is there any way to accomplish this other than using ANSI mode/Transient Journal??

Coz..ours is a very small system with 20 AMPS.

Learn And Share...

URS

Ravindra Red

Post #17276
Jim Chapman
Posted 11/6/2009 5:46:36 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Yesterday @ 8:47:37 PM
Posts: 283, Visits: 989
Both Teradata and ANSI session modes use the transient journal. Both modes support transactions that may be rolled back or committed explicitly. In Teradata mode, you can use a BEGIN TRANSACTION (or BT) statement to begin a transaction; END TRANSACTION (or ET) commits the transaction, or ABORT rolls it back. In ANSI mode, a transaction begins implicitly if a transaction is not already active when a statement is executed, and you use COMMIT or ROLLBACK to terminate the transaction.
Post #17277
ravindrareddy
Posted 11/6/2009 11:59:10 PM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 11/6/2009 11:56:30 PM
Posts: 19, Visits: 37
Hi Jim
Thanks For the Reply...

What exactly I'm looking at is...is there any alternative method to perform ROLLBACK operation if transient Journels are not taken on target table...

Learn And Share...

URS

Ravindra Red

Post #17278
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 12:02am

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.094. 9 queries. Compression Disabled.