• left outer join in trigger DB2 Z/OS

    I'm having problems writing a trigger that contains a left outer join. Here is the trigger: CREATE TRIGGER H000.H0TRCAD2 AFTER DELETE ON H000.H0COO_TRANS_CALLC REFERENCING OLD AS OLD_ROW FOR EACH ROW MODE DB2SQL BEGIN ATOMIC SELECT OLD_ROW.CLNT_ID , OLD_ROW.ACCT_NBR , OLD_ROW.PST_DT ,...

    X000055 pointsBadges:
  • How to create a trigger for updating a table for a quantity decrease?

    How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column? 1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions. 2. The trigger must fire for each row that is...

    OracleATE190 pointsBadges:
  • How to find out what is happening in a Database?

    We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database's tables. All I can report is that an insert, update or delete has occurred, the...

    Mjf75 pointsBadges:
  • How to prevent SQL update trigger from firing on insert?

    Category: SQL Server 2005, T-SQL I have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don't want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don't want to use a...

    Leo W5 pointsBadges:
  • Daily trigger in SQL

    I'm trying to create a trigger to execute daily and calculate a few averages for me. Please help!

    Barend IT15 pointsBadges:
  • trigger to update

    My Table Structure is: Table A Table B Table C colA -PK Col B-PK Col C-PK Col B-FK Col B-FK Col C-FK This relation establish a Concurrent relation where in Cascade Property fails.I can set Cascade property for any two tabnles...but not the third table. My requirement is : 1)To Update PK of Table B...

    Adithi5 pointsBadges:
  • Data Sync in tow tables

    We are in the progress of restructing the old database. In this effort , we are joining data from 3 files files and creating a new schema. in the process of migration , we need to keep the new file and the old files in sync. How do we achive this? I was planning for triggers on Old file and the New...

    Uiiuo50 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following