Clearing Workpieces from Enterprise Workflow on the iSeries

From Support

1. Make a backup copy of the RJSFLOW library.
2. From the iSeries command line type: STRSQL
3. Run each of the following SQL commands to clear the associated workflow table:

delete from rjsflow/workpiece
delete from rjsflow/workpiecehistory
delete from rjsflow/workpiecenotes
delete from rjsflow/workpieceprocess
delete from rjsflow/workpieceprocesspath
delete from rjsflow/workpiecereferences
delete from rjsflow/workpiecevalues

This article has been proofread by Jordan as of 07:27, 20 November 2007 (Central Standard Time)