Hi Jayaram,
It does not appear to me that the trigger fires any statement. After
specifying the row vs. statement behavior of the trigger, you need to
add a SQL statement which the trigger fires. The examples in the CREATE
TRIGGER section of the Reference Guide may be useful.
Hope this helps,
-Rick
Jayaram Subramanian wrote:
Hi,
When i am trying to execute the following statements
s.executeUpdate(
"create table t1 (c1 int generated always as identity, name char(32))" );
s.executeUpdate(
"create table t2 (c2 int generated always as identity, name char(32))" );
s.executeUpdate(
"create trigger insert_trigger after insert on t1 for each row" );
The trigger statement gives me an <EOF> error at line 1,column 61. Am
i missing something ?
With Regards
Jayaram
