Archives of the TeradataForum
Message Posted: Mon, 28 Apr 2008 @ 23:01:44 GMT
I wrote the following little procedure and it works fine:
replace procedure sql00.like_test2 () begin for cur_ptr as myptr cursor for select vartext from vartable where vartext like 's%' do upd sql00.vartable set vartext='s'||cur_ptr.vartext where vartext=cur_ptr.vartext; end for; end;
Hope it helps you figure out what is incorrect with yours.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|