Come for answers, stay for best practices. All we're missing is you.
Originally posted by: paul.brett
Let's say you have a scenario where you want to update a value in a lookup table, but if it is not there you want to append to the table (with a starting value of 1).
Have a look at this example which bypasses potential issues with using GETANDSET() with using the Append mode with the FILE adapter.
Thank-you.
Paul.
Follow me on Twitter