Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Appendix C SSOLite Stored Procedures : Command Procedures : SW_PURGE

SW_PURGE
The SW_PURGE procedure purges the specified case of a procedure (permanently deleting it from the system). If events are set for the OnBeforePurge event, the events will be triggered when the case is about to purge but before the case is actually purged.
Syntax
SW_PURGE (
proc_name in varchar2(8),
proc_maj_ver in number(5),
proc_min_ver in number(5),
case_number in integer)
where:
proc_name is the name of the procedure that you want to purge a case of. The case must be either active or closed.
proc_maj_ver is either the major version number of the proc_name procedure, or -1. See the notes below.
proc_min_ver is either the minor version number of the proc_name procedure, or -1. See the notes below.
case_num is the number of the case that is to be purged.
Notes
Instead of using the specific major or minor version number or both of the procedure, you can specify both the proc_maj_ver and proc_min_ver parameters as -1. If you do this, iProcess will use the version number of the procedure that the case was originally started with or, that it has subsequently been migrated to (if a subsequent version has been released while the case is still in progress).
If you specify one version number parameter as -1, you must specify the other one as -1 as well.
Example
This example purges case 103 of the CUSTREQ procedure.

 
EXEC SSOLITE.SW_PURGE ('CUSTREQ', -1, -1, 103)

 

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.