Increment an Integer Field by One

How can I increment an integer field in a table by one without first accessing that field, picking what is already in there, adding +1 and updating the record? Atomic counters was suggested, but am not sure how to implement this with that.

Hello @Nkekere_Tommy_Minimann

You can find out how to use counters in the documentation: Atomic Counters API - Increment by 1, return current

Regarding updating the column value without receiving the previous value: we are now considering adding this functionality (BKNDLSS-20855).

Do we have this feature now? I mean updating a column value without receiving the previous value. I want to be able to increment or decrement an integer field by one.

The ticket BKNDLSS-26416 is now associated with this feature. It will take about 3 weeks before it is released.


Thank you. Am waiting…