ANSI Mode BTEQ Script
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 » ANSI Mode BTEQ Script
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.


ANSI Mode BTEQ Script Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
ravindrareddy
Posted 11/6/2009 11:18:34 AM
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 All,

I need to write one Bteq script to update my table.Along with this I need to take the number of records it is going to update by running select statement before Update statement.
Once update statement is complete..I want to see how many records this Update statement has updated...
If the prior count and after counts are matching Commit this operation else through an error by releasing the lock and do a ROLLBACK.

As per my knowledge I need to go for ANSI transaction mode...

I'm very new in using ANSI mode in BTEQ...

Could any one help me in providing sample BTEQ script for this scenario...

Thanks In Advance


Learn And Share...

URS

Ravindra Red



Learn And Share...

URS

Ravindra Red

Post #17274
« 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 6:54am

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.047. 5 queries. Compression Disabled.