删除存储过程:(需要指定参数,即使是空参数)
drop procedure proc1(); --删除空参数
drop procedure proc1(int);
drop procedure proc1(varchar);
create procedure proc4()
returning int;
define i,j,sum int;
begin
let i=1;
let j=2;
let sum=(i+j);
end;
return sum;
end procedure;
execute procedure proc4();
create table t3
(
id int,
name varchar(20)
);
insert into t3 values (1,'a1');
insert into t3 values (2,'a2');
insert into t3 values (3,'a3');
create procedure proc5()
returning varchar(20);
define result varchar(20);
begin
select name into result from t3 where id=3;
end;
return result;
end procedure;
execute procedure proc5();
create procedure proc6()
returning varchar(50);
define result varchar(50);
define a,b int;
begin
let a=10;
let b=20;
if(a>b) then
let result= 'a > b';
elif(a==b) then
let result = 'a = b';
else
let result = 'a < b';
end if;
end;
return result;
end procedure;
execute procedure proc6();
echo 'execute procedure proc6()' | dbaccess java2
create procedure proc7()
returning varchar(50);
define i int;
begin
for i=4 to 100
insert into t3 value
drop procedure proc1(); --删除空参数
drop procedure proc1(int);
drop procedure proc1(varchar);
create procedure proc4()
returning int;
define i,j,sum int;
begin
let i=1;
let j=2;
let sum=(i+j);
end;
return sum;
end procedure;
execute procedure proc4();
create table t3
(
id int,
name varchar(20)
);
insert into t3 values (1,'a1');
insert into t3 values (2,'a2');
insert into t3 values (3,'a3');
create procedure proc5()
returning varchar(20);
define result varchar(20);
begin
select name into result from t3 where id=3;
end;
return result;
end procedure;
execute procedure proc5();
create procedure proc6()
returning varchar(50);
define result varchar(50);
define a,b int;
begin
let a=10;
let b=20;
if(a>b) then
let result= 'a > b';
elif(a==b) then
let result = 'a = b';
else
let result = 'a < b';
end if;
end;
return result;
end procedure;
execute procedure proc6();
echo 'execute procedure proc6()' | dbaccess java2
create procedure proc7()
returning varchar(50);
define i int;
begin
for i=4 to 100
insert into t3 value