Add transaction feature to sql statement

chulett · Post by **chulett** » Thu Jun 23, 2005 6:35 am

In the 'Before SQL' tab of the stage.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 23, 2005 6:38 am

But you do not have a 'Before-SQL' tab in ODBC stage.

chulett · Post by **chulett** » Thu Jun 23, 2005 6:51 am

Stupid stage. Can you tell I hardly ever use it? :lol:

What about the Informix stage, does it support that concept? Without that, I'm afraid the OP would be out of luck unless there is a different answer to the problem other than having to set the lock mode.

roy · Post by **roy** » Thu Jun 23, 2005 7:41 am

Hi,
did you try using user defined sql with lets say:
set lock mode to wait n; select ......
?