Hi,
I am getting a serious problem when executing the trigger. I have a
simple table like this
CREATE TABLE "TESTUSER"."UNITS"
(
"UNITSINDEX" Integer DEFAULT SERIAL (1),
"NAME" Varchar (20) ASCII,
"UNITTYPE" Varchar (4) ASCII NOT NULL,
"RECORDTIME" Timestamp DEFAULT TIMESTAMP,
"DELETEFLAG" Boolean DEFAULT FALSE,
PRIMARY KEY ("UNITSINDEX")
)
I have a trigger for the above table like this
CREATE TRIGGER timeupd FOR units AFTER UPDATE EXECUTE
(update TESTUSER.UNITS set recordtime=timestamp where
unitsindex=:OLD.unitsindex;)
But when I execute an update statement on this table, I ma getting the
following error message
E -25009: Failure in db communication (receive): 1 = connection
broken
The above is happening for the database(SAPDB Version 7.3.0.23) running
on Linux server.
Strangely, I am able to execute all this without errors on the database
installed on local machine(windows 2000 professional,SAPDB Version
7.3.0.24).Can someone help me with this?
Regards,
Ravi Kora
[EMAIL PROTECTED]
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
