my stored procedure in db2 is--->
create procedure temp_bill(in UPC_cd character(6))
language sql
begin
declare prod_cd character(8);de clare prod_desc varchar(30);dec lare discount decimal(2,2);de clare
prod_sp decimal(7,2);de clare
counts int;declare deal_check char(6);select
deal_id into deal_check from db2admin.produc t where db2admin.produc t.upc_cd=UPC_cd ;if deal_check is not null then select...