trigger insert 1

[Wanjaya]

hi,
i got error when creating trigger..

CREATE TRIGGER INSERT_PSM1
INSERT ON PSM1
REFERENCING NEW AS NEW_DATA
FOR EACH ROW (
INSERT INTO AP_CREDITOR (
SIRI_NO)
VALUES (
NEW_DATA.SIRI_NO)
)

Error: Could not open database table (mpsm.psm1). (State:S1000, Native Code: FFFFFF0E)

what should i do? psm1 is under schema mpsm while ap_creditor is under schema informix. someone pls help me

 

[vpshriyan]

Hi,

Error: Could not open database table (mpsm.psm1).

The above error message basically implies that while creating the trigger the database server was unable to lock the table psm1 in exclusive mode.

It is to be noted that inorder to get through the creation of any type of trigger, the dbserver process tries to put an exclusive lock on the source table for a split second. If if finds any sessions accessing the table even for read purpose, it rejects the trigger creation command.

You may retry your operation, when there is no activity in the table psm1.

Regards,
Shriyan

"Knowledge comes, but wisdom lingers."