Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011

    Unanswered: HELP with TRIGGERS.

    I have these questions for my assignment?
    I have created tables and inserted data and everything but I am stuck with triggers.

    a. Write a trigger to be executed on insert of PROPERTY to initialize date_of_insert and expiration_date to Sysdate.

    b. Write a Procedure/trigger to be executed on insert, update of a PROPERTY Every property that gets entered gets checked against other properties of having the same: Agent(s), Owner(s), Location (City, State, Address), if you find one then update Property Status to “Double” as a duplicate

    c. Write a trigger to be executed on update of a PROPERTY when the status field is changed from “NEW” to “APROVED” then update expiration date with today’s date (Sysdate) + 90 days.

  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts