CONNX Data Integration Suite
14.8.0 |
Reference Guide
|
SQL Grammar
|
SQL Decision Tree Functions
|
Quick Links to SQL Decision Tree Functions
Quick Links to SQL Decision Tree Functions
"C" Functions
CNXNAME (string_exp, nameformat_exp, nameoutput_exp)
CNXPREFERENCE( likeclause_count, like_clause_1, like_clause_2, ... , criteria1_exp, value1_exp, criteria2_exp, value2_exp, ... )
COALESCE(exp1, exp2, ...)
"I" Functions
IF(criteria_exp,then_exp,else_exp)
IFEMPTY (exp1, exp2)
IFNULL(exp1, exp2)
"N" Functions
NULLIF(exp1, exp2)
"S" Functions
SWITCH(criteria_exp, compare1_exp, return1_exp, compare2_exp, return2_exp,...,[default_return_exp])