An unexpected token “CREATE TRIGGER

by

You have 2 things going on here –

1) When the “;” character is part of the SQL statement, it’s necessary to use a different character to terminate the statement. I typically use “@”. To tell the “db2” command that you have chosen a different character, use

db2 -td@

or if you want to read from a file

db2 -td@ -f <somefile>

2) The correct way to update new row in a trigger is to set an alias for the new row, and use a set clause:

CREATE TRIGGER TRG_EFMREFNO 
   BEFORE 
   INSERT ON FEEDBACK_CASE_TB 
   REFERENCING NEW AS N
   FOR EACH ROW 
   BEGIN 
       SET N.EFMREFNO = SEQ_EFMREFNO.NEXTVAL;
   END
@

There may be other ways to use the sequence with the default clause in the create table statement that will accomplish the same thing:

More Related Contents:

  1. SQL update from one Table to another based on a ID match IN db2
  2. Equivalent of LIMIT for DB2
  3. Environment COBOL, C, DB2 on Ubuntu [closed]
  4. DB2 Comma Separated Output by Groups
  5. Relationship between catalog, schema, user, and database instance
  6. Does DB2 have an “insert or update” statement?
  7. how to transform comma separated column into multiples rows in db2
  8. INNER JOIN in UPDATE sql for DB2
  9. Pivoting in DB2
  10. Regular Expressions in DB2 SQL
  11. How to split a string value based on a delimiter in DB2
  12. How to resolve SQL0418N Error
  13. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  14. Query validation using C#
  15. DB2 Query to retrieve all table names for a given schema
  16. How to check db2 version
  17. What does a timestamp in T-Sql mean in C#?

Leave a Comment