I have stored procedure sql server code:
if ( <condotion>)
if @@trancount>0 rollback tran
I would like to convert this code to teradata T-mode (within stored procedure).
Any idea how i'm codeing this on teradata?
Thanks in advance
You would Declare a Condition for trancount > 0, and Declare a Continue Handler for that condition. For details, go to info.teradata.com and get the "SQL Stored Procedures and Embedded SQL" manual for your Teradata release.