skip to main content
SQL Engine parse tree methods for .NET : SQL pass-through and advanced query methods reference : damex_describeCaseValExp
 

damex_describeCaseValExp

This method retrieves the description of a conditional CASE expression. The method returns a description of two formats for CASE expression, as follows:
1. Simple CASE expression
CASE input_expression
WHEN when_expression THEN result_expression
[...]
[
ELSE else_result_expression
]
END
2. Searched CASE expression:
CASE
WHEN Boolean_expression THEN result_expression
[...]
[
ELSE else_result_expression
]
END

Syntax 

int damex_describeCaseValExp(
out int64 hCaseValExp,
out int64 phInputValExp,
out int64 phCaseElemList,
out int64 phElseValExp)
 
Table 210: Parameters for damex_describeCaseValExp 
Parameter
Type
Description
IN
 
 
hCaseValExp
int64
Case value expression handle.
OUT
 
 
phInputValExp
int64
Handle to the input expression This value is set only when the CASE is a simple expression.
phCaseElemList
int64
Handle to the input expression. This value is set only when the CASE is a simple CASE expression.
phElseValExp
int64
Handle to the WHEN-THEN expression list. Use damex_getFirstCaseElem and damex_getNextCaseElem.
RETURN
 
 
 
int
DAM_SUCCESS – on success
DAM_FAILURE – on failure

See also 

• damex_getFirstCaseElem
• damex_getNextCaseElem