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

damex_describeCaseElem

This method retrieves the details of the WHEN-THEN Case element of the CASE expression. The WHEN-THEN expression has one of the following formats:
1. Simple Case
WHEN when_expression THEN result_expression
2. Searched Case
WHEN boolean_expression THEN result_expression

Syntax 

int damex_describeCaseElem(
int64 hCaseElem,
out int64 phWhenValExp,
out int64 phWhenBoolExp,
out int64 phResValExp)
 
Table 209: Parameters for damex_describeCaseElem  
Parameter
Type
Description
IN
 
 
hCaseElem
int64
Element handle of the WHEN-THEN expression.
OUT
 
 
phWhenValExp
int64
The handle to the WHEN value expression. This value is set only when the Case is a simple Case expression.
phWhenBoolExp
int64
The handle to the WHEN boolean expression. This value is set only when the Case is a searched Case expression.
phResValExp
int64
The handle to the result expression.
RETURN
 
 
 
int
DAM_SUCCESS – on success
DAM_FAILURE – on failure