SW_GETCASE_STATUS

Copyright © Cloud Software Group, 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),
proc_type varchar(10),
case_started timestamp)

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.

CALL owner.SW_GETCASE_STATUS (8, ?, ?, ?)/

This results in output displaying the status of the case (as well as the procedure type and date and time the procedure was started). For example:

Active

Main

MAY 25 2005 3:36PM