my stored procedure in db2 is--->
create procedure temp_bill(in UPC_cd character(6))
language sql
begin
declare prod_cd character(8);declare prod_desc varchar(30);declare discount decimal(2,2);declare
prod_sp decimal(7,2);declare
counts int;declare deal_check char(6);select
deal_id into deal_check from db2admin.product where db2admin.product.upc_cd=UPC_cd;if deal_check is not null then select
prod_id,prod_desc,buy_discount,prod_sp into prod_cd,prod_desc,discount,prod_sp from db2admin.product,db2admin.deal where
db2admin.product.upc_cd=UPC_cd and db2admin.deal.deal_id=db2admin.product.deal_id;els e select prod_id,
prod_desc,prod_sp into prod_cd,prod_desc,prod_sp from db2admin.product
where db2admin.product.upc_cd=UPC_cd;end if;end
i am getting error of SQL0811N The result of a scalar fullselect, SELECT INTO statement, or VALUES INTO statement is more than one row.
even my first select statement is having same error in this procedure.
what should i do please help.its very urgent!!