odbtools/odbctest/mql/basic/19batch_update/11data.mql

select * from /test/batch
/**
output()
**/
;

BEGIN BATCH
	
	update /test/batch set v_float = 1.2 where v_varchar='4006' ;
	
	update /test/batch set v_float = 1.2 where v_varchar='40' ;
	
	update /test/batch set v_float = 1.2 where v_varchar='400';
	
	update /test/batch set v_float = 1.2 where v_varchar='74006';
	
	update /test/batch set v_float = 1.2 where v_varchar='409';
	
	update /test/batch set v_float = 1.2 where v_varchar='500';
	
	update /test/batch set v_float = 1.2 where v_varchar='600';
	
	update /test/batch set v_float = 1.2 where v_varchar='700';
	
	update /test/batch set v_float = 1.2 where v_varchar='602';
	
	update /test/batch set v_float = 1.2 where v_varchar='708';

END
;