Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix B SSOLite Stored Procedures : Data Procedures : SW_ADD_PACK_DATA

SW_ADD_PACK_DATA
The SW_ADD_PACK_DATA procedure defines an item of pack data (a field name/value pair) that will be passed to iProcess with the next command procedure that is called.
Syntax
SW_ADD_PACK_DATA (
field_name varchar(31),
field_value varchar(255))
where:
field_name is a string that specifies the name of the iProcess field that is to be set.
field_value is a string that specifies the value to be set for field_name.
Notes
SW_ADD_PACK_DATA allows pack data to be passed to iProcess when a command procedure is called:
You must call SW_ADD_PACK_DATA to specify the pack data immediately before calling the desired command procedure.
A call to SW_ADD_PACK_DATA defines a single item of pack data. If you wish to define multiple items of pack data, you must make a SW_ADD_PACK_DATA call for each piece of data before calling the desired command procedure.
Examples
In the following example, two SW_ADD_PACK_DATA calls are used to define data values for the F1 and F2 fields, which are passed to iProcess when Case1 is started (using SW_CASESTART). The second SW_CASESTART call, starting Case2, does not have any data values.

 
CALL owner.SW_ADD_PACK_DATA ('F1', 'DataItem1')/
CALL owner.SW_ADD_PACK_DATA ('F2', 'DataItem2')/
CALL owner.SW_CASESTART ('CUSTREQ', -1, -1, 'Case1', 'user35', '', ?, ?)/
CALL owner.SW_CASESTART ('CUSTREQ', -1, -1, 'Case2', 'user35', '', ?, ?)/

 
If you want to specify pack data for the F1 and F2 fields for Case2 as well, you must call SW_ADD_PACK_DATA again before calling SW_CASESTART, as shown below.

 
CALL owner.SW_ADD_PACK_DATA ('F1', 'DataItem1')/
CALL owner.SW_ADD_PACK_DATA ('F2', 'DataItem2')/
CALL owner.SW_CASESTART ('CUSTREQ', -1, -1, 'Case1', 'user35', '', ?, ?)/
CALL owner.SW_ADD_PACK_DATA ('F1', 'DataItem1')/
CALL owner.SW_ADD_PACK_DATA ('F2', 'DataItem2')/
CALL owner.SW_CASESTART ('CUSTREQ', -1, -1, 'Case2', 'user35', '', ?, ?)/

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved