DB2学习笔记-存储过程
存储过程的作用：
Connect to sample@drop table test@create table test (id int ,name char (20))@insert into test values(1,'张三')@insert into test values (2,'李四')@Create procedure view( In i int,out vname char(20))Language sqlBegin // 游标方式 // Declare c1 cursor for Select name from test where id =i; Open c1; Fetch from c1 into vname; Close c1; // 普通方式// declare temp char(20); For temp as select name from test where id=i do Set vname = temp.name End for;end@
