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


Appendix B SSOLite Stored Procedures : Command Procedures : SW_GRAFT

SW_GRAFT
The SW_GRAFT procedure grafts a sub procedure onto a graft step in a main procedure. The case data is added to the sub-procedure.
Syntax
SW_GRAFT (
proc_name varchar(8),
proc_maj_ver integer,
proc_min_ver integer,
case_number numeric(20),
graft_step_name varchar(8),
graft_proc_name varchar(8),
graft_proc_maj_ver integer,
graft_proc_min_ver integer,
graft_id varchar(49))
where:
proc_name is the name of the parent procedure that you want to graft a sub-procedure to.
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 you want to graft a sub-procedure to.
graft_step_name is the name of the graft step in the proc_name procedure that the sub-procedure is to be grafted to.
graft_proc_name is the name of the sub-procedure that is to be grafted to the proc_name parent procedure.
graft_proc_maj_ver is either the major version number of the graft_proc_name procedure, or -1. See the notes below
graft_proc_min_ver is either the minor version number of the graft_proc_name procedure, or -1. See the notes below
graft_id is a unique identifier for this instance of the graft_step_name graft step.
Notes
Instead of using the specific major and/or minor version number 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 graft steps and how to use them, see TIBCO iProcess Modeler Integration Techniques.
Example
This example uses SW_GRAFT to graft the SUBPROC1 sub-procedure to step GRAFT01 of case 101 of the CUSTREQ procedure. It then uses SW_GRAFTCOUNT to specific that a single item is to be grafted to the UNIQUEID instance of the graft step.

 
CALL owner.SW_GRAFT ('CUSTREQ', -1, -1, 101, 'GRAFT01', 'SUBPROC1', -1, -1, 'UNIQUEID')/
CALL owner.SW_GRAFTCOUNT ('CUSTREQ', -1, -1, 101, 'GRAFT01', 'UNIQUEID', 1)/

 

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