Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb


HeatWave User Guide  /  ...  /  Control Flow Functions and Operators

11.2.5 Control Flow Functions and Operators

The following table shows supported control flow operators. The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. See Section 3.3, “Encoding String Columns”.

Table 11.4 Control Flow Functions and Operators

Name VARLEN Support Description
CASE Yes Case operator
IF() Yes If/else construct
IFNULL() Yes Null if/else construct
NULLIF() Yes Return NULL if expr1 = expr2