Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Appendix B SSOLite Stored Procedures : Command Procedures : SW_GETCASE_STATUS

SW_GETCASE_STATUS
The SW_GETCASE_STATUS procedure returns the status of a case of a procedure.
Syntax
SW_GETCASE_STATUS (
case_num numeric(20),
case_status varchar(10) output,
proc_type varchar(10) output,
case_started datetime output)
where:
case_num is the number of the case that you want to get the status of.
case_status (output) is the name of a variable, defined in the calling program, into which SW_GETCASE_STATUS will return the status of the specified case.
proc_type (output) is the name of a variable, defined in the calling program, into which SW_GETCASE_STATUS will return the procedure type of the specified case (for example, Main or Sub).
case_started (output) is the name of a variable, defined in the calling program, into which SW_GETCASE_STATUS will return the date and time that the case was started.
Example
This example displays the status of case 8.

 
Declare @case_status as varchar(10)
Declare @proc_type as varchar(10)
Declare @case_started as datetime
EXEC owner.SW_GETCASE_STATUS 8, @case_status output, @proc_type output, @case_started output
print 'Case status :'+@case_status
print 'Proc Type :'+@proc_type
print 'Case started : '+ cast(@case_started as varchar)

 
This results in output displaying the status of the case. For example:

 
Case status :Active
Proc type :Main
Case started : MAY 25 2005 3:36PM

 

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.