Question
· Jul 12, 2020

SQL CREATE TRIGGER command - SQLCODE: <-300>:

Hello, I am running into a little problem.

I am trying to create a Cache Trigger on a FACS table using the SQL CREATE TRIGGER command but I am getting the message [SQLCODE: <-300>:<DDL not allowed on this table definition>].

I am not creating a persistent class but using the SQL CREATE TRIGGER command.

Please advise.

thanks.

Discussion (8)0
Log in or sign up to continue

Update:

I was able to successfully attach the trigger to the cache table Dbtr_Clnt_Generl_Inf but when the user changes any of the fields the trigger is monitoring the trigger does not appear to fire and the add entry into the log table.

The same trigger works for the test cache tables I created but does not work when attached to the production table within Cache.

Is there something else that needs to be done.? The only difference is the trigger is attached to the live production table.