committing a teradata update

general discussion
1

I created a macro in Teradata Sql Assistant that does an update and then selects the rows it just updated.

When I execute the macro from BO free-hand sql, it runs but does not commit the updates. I have all the correct permissions and have tried changing the ODBC connection to have Session Mode set to Teradata. I can’t type in COMMIT into the macro or I get :
Code = 3706.
3706: Syntax error: COMMIT WORK not allowed for a DBC/SQL session.

Any help would be great!

jammin41 (BOB member since 2005-11-28)

2

I just needed to add a “End Transaction” at the end of the macro. There must be an implicit “Begin Transaction” somewhere in BO, but there’s not one in my macro. :?

jammin41 (BOB member since 2005-11-28)