Copyright © Cloud Software Group, Inc. All rights reserved.
Copyright © Cloud Software Group, Inc. All rights reserved.


Appendix B SSOLite Stored Procedures : Command Procedures : SW_ACTIVATE

SW_ACTIVATE
The SW_ACTIVATE procedure re-activates a previously suspended case of a procedure.
Syntax
SW_ACTVATE (
proc_name varchar(8),
proc_maj_ver integer,
proc_min_ver integer,
case_number numeric(20),
user_id varchar(24))
where:
proc_name is the name of the procedure that you want to reactivate 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 suspended case that is to be reactivated.
user_id is the name of the iProcess user who is re-activating the case.
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 re-activates case 103 of the CUSTREQ procedure.

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

 

Copyright © Cloud Software Group, Inc. All rights reserved.
Copyright © Cloud Software Group, Inc. All rights reserved.