Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Appendix B SSOLite Stored Procedures : Command Procedures : SW_SUSPEND

SW_SUSPEND
The SW_SUSPEND procedure suspends a case of a procedure.
Syntax
SW_SUSPEND (
proc_name varchar(8),
proc_maj_ver integer,
proc_min_ver integer,
case_number numeric(20),
user_id varchar(24),
suspend_type integer)
where:
proc_name is the name of the procedure that you want to suspend a case of.
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_number is the number of the case that is to be suspended.
user_id is the name of the iProcess user who is suspending the case.
suspend_type defines the type of suspend action. This should always be 2.
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.
For more information about how to suspend and re-activate a case, please see the TIBCO iProcess Objects and TIBCO iProcess Server Objects programmer guide.
Example
This example suspends case 103 of the CUSTREQ procedure.

 
CALL owner.SW_SUSPEND ('CUSTREQ', -1, -1, 103, 'swadmin', 2)/

 

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved