View Single Post
  #10 (permalink)  
Old 09-01-10, 11:47
Jack Vamvas Jack Vamvas is offline
Registered User
 
Join Date: Jan 2009
Posts: 57
Try :
create procedure update_discount(in discount decimal(4,2))
language sql
begin
update Sales set Sales_Amount=Sales_Amount*discount where
Sales_Quantity >=2;
end@
TERMINATE@



then place in a file - and run from an interface - such as Putty - as :

db2 -td@ -f myfilename.sql
__________________
-------------
DBA DB2
SQL SERVER DBA
Reply With Quote