By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,611 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,611 IT Pros & Developers. It's quick & easy.

please help me

P: 1
Hi, I'm trying to create a simple database for an library system, It's just an practical assignment not for using in real world :-) my problem is about the trigger which is about "create a trigger that identifies any items that are overdue and calculate the penalty to be issued to the member" I alter a column which keeps the difference between Return_date and Due_date, This information are in Member_Item table, Loan_Type of the book is defined in LibraryItem table. my solution is as bellow:

create trigger trg_penalty
after insert of Return_date on Member_Item
for each row db2sql
update Member_Item
set Penalty = (no_ofday * 0.10)
where LibraryItem.Loan_Type = 'normal';

could anybody please tell me what is wrong with my trigger?
Thank you
Sep 8 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.