<div>
<br />
DB2 error messages tend to steer your eyes away from the real problem. &nbsp;(BTW, this isn't unique to IBM's SQL.)<br />
<br />
Remove the ';' from the INSERT statement and try again.<br />
<br />
<br />
Kent<br />

</div>



DB2 error messages tend to steer your eyes away from the real problem.  (BTW, this isn't unique to IBM's SQL.)

Remove the ';' from the INSERT statement and try again.


Kent


<div>
<div class="content wysiwyg-content">
Hi, <br />
I am trying to write a trigger on a table. I have written following code<br />
CREATE TRIGGER QGPL/TRG_TEST &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
AFTER INSERT ON QGPL/TESTTRIGGER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
REFERENCING NEW ROW AS NROW &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
FOR EACH ROW MODE DB2ROW &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
<br />
WHEN (NROW.SOSTAT = 'ASSN') &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
BEGIN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; INSERT INTO QGPL/TESTTRIGGER values(NROW.SONO, 'AUTO', NROW.SOTYP); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
END<br />
<br />
But i am getting error as<br />
Character ''' not valid following string ', &nbsp; &nbsp; &nbsp; &nbsp; '. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
String '); &nbsp; &nbsp; &nbsp; &nbsp;' contains a character that is not valid. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
Please help.<br />
Thanks.<br />

</div>
</div>


Hi, 
I am trying to write a trigger on a table. I have written following code
CREATE TRIGGER QGPL/TRG_TEST                              
AFTER INSERT ON QGPL/TESTTRIGGER                              
REFERENCING NEW ROW AS NROW                      
FOR EACH ROW MODE DB2ROW                                                

WHEN (NROW.SOSTAT = 'ASSN')  
                                                           
BEGIN                                                      
  INSERT INTO QGPL/TESTTRIGGER values(NROW.SONO, 'AUTO', NROW.SOTYP);	 
END

But i am getting error as
Character ''' not valid following string ',         '.               
String ');        ' contains a character that is not valid.          
Please help.
Thanks.


DB2 Trigger Error.

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.