Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Posts
    2

    Unanswered: jcc cann't create trigger

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I do not know if this will fix it, but remove the semicolon after END.

    Andy

  3. #3
    Join Date
    Sep 2010
    Posts
    2

    thank you for your reply

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

Posting Permissions

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