<div>
Hi JD,<br />
<br />
I believe that you want a BEFORE trigger here.<br />
<br />
<br />
Kent<br />

</div>


Hi JD,

I believe that you want a BEFORE trigger here.


Kent


<div>
This is the error we are getting:<br />
I don't understand as we are only using one table here.<br />
<br />
-- Failure!!!<br />
-- [IBM][CLI Driver][DB2/NT64] SQL0203N &nbsp;A reference to column &quot;USER9&quot; is ambiguous. &nbsp;LINE NUMBER=8. &nbsp;SQLSTATE=42702
</div>


This is the error we are getting:
I don't understand as we are only using one table here.

-- Failure!!!
-- [IBM][CLI Driver][DB2/NT64] SQL0203N  A reference to column "USER9" is ambiguous.  LINE NUMBER=8.  SQLSTATE=42702

<div>
That worked.<br />
Thanks <br />

</div>


<div>
<div class="content wysiwyg-content">
I'm trying to create a trigger to update one field off another within the same table. &nbsp;Something is wrong with the syntax.<br />
Can someone help?<br />
<br />
<br />

<pre><code id="code-603125">CREATE TRIGGER CUST_TLO_APPT_FLAG
AFTER UPDATE OF DELIVERY_APPT_REQ ON TLORDER
REFERENCING NEW AS N OLD AS O
FOR EACH ROW
MODE DB2SQL
BEGIN ATOMIC
  IF O.DELIVERY_APPT_REQ = 'False' and N.DELIVERY_APPT_REQ = 'True' THEN SET USER9 ='Y' ;
  END IF;
  IF O.DELIVERY_APPT_REQ = 'True' and N.DELIVERY_APPT_REQ = 'False' THEN SET USER9 ='' ;
  END IF;
END@
</code></pre>
</div>
</div>


I'm trying to create a trigger to update one field off another within the same table.  Something is wrong with the syntax.
Can someone help?



DB2 Trigger

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.