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@

命令行执行db2 call view(1,?)后，可取到i为1的vname值。