informix 存储过程小实验2

--9、RETURNING返回值
drop procedure test;
create procedure test()returning int;
define x int;
define y int;
let x = 30;
let y = 20;
if x < y then
return 0;
else
return 1;
end if;
end procedure;
execute procedure test();
--10、变量的带法
drop procedure test;
create procedure test()returning int,int,int;
define x,y int;
let x,y = 30,20;
if x < y then
return 1,2,3;
else
return 3,2,1;
end if;
end procedure;
execute procedure test();
--11、赋值
drop procedure test;
create procedure test(t varchar(50))returning int;
update table1 set name=t where nameid=1;
return 0;
end procedure;
execute procedure test('Tommy');