Skip to Content

SAP HANA XSA: Trigger for column tables not supported?

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 06, 2017 at 03:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded