Creating triggers

TABLE DETAILS:
Table name:-DUMMY1
details:student_no INTEGER,college varchar(20),age smallint

TRIGGER STATEMENT:

create trigger trigger_dummy1 after insert on dummy1 for each row mode db2sql update set student_no = student_no +1

ERROR DISPLAYED:

------------------------------ Commands Entered ------------------------------
connect to sampl;
create trigger trigger_dummy1 after insert on dummy1 for each row mode db2sql update set student_no = student_no +1;
------------------------------------------------------------------------------
connect to sampl

Database Connection Information

Database server = DB2/NT 8.2.3
SQL authorization ID = ADMINIST...
Local database alias = SAMPL


create trigger trigger_dummy1 after insert on dummy1 for each row mode db2sql update set student_no = student_no +1
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "student_no" was found following "de db2sql
update set". Expected tokens may include: "SET". LINE NUMBER=1.
SQLSTATE=42601

SQL0104N An unexpected token "student_no" was found following "de db2sql update set". Expected tokens may include: "SET ".

Explanation:

A syntax error in the SQL statement or the input command string
for the SYSPROC.ADMIN_CMD procedure was detected at the specified
token following the text "<text>". The "<text>" field indicates
the 20 characters of the SQL statement or the input command
string for the SYSPROC.ADMIN_CMD procedure that preceded the
token that is not valid.

As an aid, a partial list of valid tokens is provided in the
SQLERRM field of the SQLCA as "<token-list>". This list assumes
the statement is correct to that point.

The statement cannot be processed.

User Response:

Examine and correct the statement in the area of the specified
token.

sqlcode : -104

sqlstate : 42601