Help Center/ Data Warehouse Service/ Tool Guide/ DSC/ Netezza Syntax Migration/ Operator
Updated on 2025-04-10 GMT+08:00
View PDF

Operator

**

Netezza Syntax

Syntax After Migration

 
1
 
V_Out := V_Out + v_J * ( v_N ** v_K ) ;

1
 
V_Out := V_Out + v_J * ( v_N ^ v_K ) ;

NOTNULL and ISNULL

Netezza Syntax

Syntax After Migration

 
1
 
CASE WHEN ((A1.EXCEPT_OFF_SEQU_NO NOTNULL) AND (A2.LOG_SEQU_NO ISNULL)) THEN 0 ELSE 1 END AS FLG

1
 
CASE WHEN ((A1.EXCEPT_OFF_SEQU_NO NOTNULL) AND (A2.LOG_SEQU_NO ISNULL)) THEN 0 ELSE 1 END AS FLG
Parent topic: Netezza Syntax Migration