Posted: Thu Jun 23, 2005 6:35 am
In the 'Before SQL' tab of the stage.
DSXchange
A short text to describe your forum
https://www.dsxchange.com/
Add transaction feature to sql statement
Page 1 of 1
Posted: Thu Jun 23, 2005 6:38 am
But you do not have a 'Before-SQL' tab in ODBC stage.
Posted: Thu Jun 23, 2005 6:51 am
Stupid stage. Can you tell I hardly ever use it? 
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.
Posted: 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 ......
?
did you try using user defined sql with lets say:
set lock mode to wait n; select ......
?