how to update database with the database adapter?

Summary

need to update rows based on a value found in one of the fields

Content

Hello Gurus,

I'm processing data from a database using the DB adapter. I'm able to get data from the database.

after processing that data, i want to use the primary key from that row of data to update a field value.

 

the workflow is:

Get data from DB
     for each row
          process data
          update a field in db to know its been processed.
     end loop
end orchestration

 I tried the the update option in the connection configuration, but I can only map data, I'm guessing this will perform an update on the entire field vs updating the field where the primary key is found.