Trigger for the batch insert

[former_member511331]

Hi,

We have a requirement to run the trigger once after the batch call. Normally if we send a batch of 1000 records the triggers runs 1000 times. Is there any solution to that.

We also tried to write "AFTER EACH STATEMENT" but it threw an error saying not supported with column table

[lbreddemann · Accepted solution]

rax your comment sound as if you want to create a data transfer automation based on triggers.

I guess it's obvious how that is not the best of ideas. If you need batch-wise processing, I'd recommend doing this explicitly in a stored procedure, a HANA flow graph or in your application code where you have a lot more control about what and when things are happening.

[lbreddemann]

What is the once-per-batch trigger supposed to do?

[former_member511331]

for example for each batch insert we want to transfer the data from one table to another.