Database Triggers and Actions - Database Update Action

Results

The Database Update Action returns its result in the flow context variable “result”. The result contains the number of rows that were affected by the update. You can access the result from the following field:

Flow Context Variable Field Java Type Description Prescript / Postscript Example
RESULT result int The number of rows that were affected by the update. int result = flowContext.get("RESULT").result; System.out.println("Number of Rows: " + result);

Passing Results with a Runtime Data Map

You can use a Runtime Data Map to copy the result field into a new variable (for future reference or to reuse the data later in the workflow).

To copy the result, you can use a data map like:

Instruction 1 of 1