To clear workpieces in Enterprise Workflow on the iSeries:

  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

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016