Skip to Content
0

SAP HANA XSA: Trigger for column tables not supported?

Oct 05, 2017 at 07:46 PM

82

avatar image

Hi,

I try to trigger our column tables by design time object .hdbtrigger.

Now I'm facing this error msg.

"feature not supported: Cannot create statement trigger on column table"

Are the triggers not supported for column tables? Couldn't find a hint within the documentation.

Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Oct 06, 2017 at 03:19 AM
0

It seems that you are trying to create a statement level trigger. Such kind of triggers are only supported by row-store tables as mentioned by the documentation for the CREATE TRIGGER statement.

"

STATEMENT

Specifies that a statement-level trigger is used. This is fired once for each triggering event. Row-store tables only support statement-level triggers.

"

Regards,
Florian

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you!

0