Thank you for your reply.

This just brings up another question.

What happens if within one "instance" that the user is updating data in database while the timer fires up another process to update data in the same database. both processes could update the same table at the same time or update different tables. If a global workspace and/or connection is defined for that instance, will the begin/commit/rollback transactions affect one another?