ANSI Mode BTEQ Script

Tools
Enthusiast

ANSI Mode BTEQ Script

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