SW_ACTIVATE

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')/