Archives of the TeradataForum

Message Posted: Tue, 11 Nov 2008 @ 13:42:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

try

     begin transaction;
     locking table tablea for write;

     sel value
           into :output_value
     from tablea;

     update tablea
          set value = value + 1;

     end transaction;

BR

Christian

	<Prev	Next>		<<First	<Prev	Next>	Last>>