db2 create trigger

1, If you create a DB2 trigger
2, Create table test: create table test_insert_trigger_table (id int ,name varchar(10),val int) ;
3, Create a trigger: create trigger afterInsertTest after insert on test_insert_trigger_table referencing new as N for each row begin set N.val = 100 ; end ;
Create trigger statement execution error, please master Zhijiao,

Started by Vern at December 08, 2016 - 7:27 AM

What is the specific information?

Posted by Sean at December 19, 2016 - 8:11 AM

" This SQL syntax is either invalid or is not currently supported. You can manually enter SQL. Some SQL builder functions have been disabled. To enable these functions, change the syntax. " The SQL syntax is either invalid or does not currently support. You can manually enter the SQL. Some of the SQL builder feature has been disabled. To enable these features, changing the grammar. This is suggested after the statement is executed, the current version of DB2 is v8.1.0.56, please advice, thank you

Posted by Vern at December 25, 2016 - 8:29 AM

create table test_insert_trigger_table (id int ,name varchar(10),val int) ;
create table test_insert_trigger_table (id int ,name varchar(10),val int)
DB20000I The SQL command completed successfully.
Is not your version of the problem. . . .

Posted by Upton at January 06, 2017 - 9:14 AM

The version of the problem is what meaning, the version of the low will not? Create the trigger which how to do?

Posted by Vern at January 13, 2017 - 9:37 AM