You can also look into the Run Process command: Application-Release-Pending
---
Causes database operations caused by the current workflow to be sent
to the database immediately.
Note: Use this advanced feature with caution. The command allows
workflow to see the results of previous workflow by causing the
previous workflow's actions to be entered into the database. Using
this command, for example, would cause the results of a Push Fields
phase 2 action to be made visible to a Set Fields phase 1 action.
However, if there is a failure after the application command is
performed, the entire transaction including the Push Fields operation
is rolled back, maintaining transactional integrity.
----
--
Jarl
On 4/27/06, Mike White <[EMAIL PROTECTED]> wrote:
Listers,
I have an interesting question that one of you may be able to help
with. I have recursive Filters that process records from a driver table,
triggering massive updates to multiple tables (to distribute a change). As
is, it's too large for multiple entries, causing database timeout errors.
Processing records in the driver table one-at-a-time works fine.
Just before my GOTO (very near the end of the last Filter), I'd like
to insert a Direct SQL COMMIT. As I understand it, the COMMIT will
terminate the transaction and write to disk. I suspect (hope) that it
won't also terminate Filter processing. My goal is to fully process one
record from the driver table, commit my work to clear the transaction, then
return/get next record and continue to the end (with no db timeout).
Does this make sense? Am I on the right track?
We're running ARS 6.0.1, patch 1380 on an Oracle 9i database, on
Solaris 5.9.
Thanks in advance for any insight you can provide!
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
