This SQL "CREATE TRIGGER b_new_file_dbr_dsf AFTER insert ON ADMINISTRATOR.TABLE1 REFERENCING NEW AS NEW FOR EACH ROW BEGIN ATOMIC insert into table3 values(1); END;"
Iam getting this errror while using jcc connectivity.
---------------------------------------------------
Caused by: com.ibm.db2.jcc.am.vo: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;able3 values(1); END;END-OF-STATEMENT, DRIVER=4.8.87

But in TODA,it runs well

I do not know if this will fix it, but remove the semicolon after END.

Andy

I removed that semicolon ,Then the SQL can run in JDBC