更新时间:2024-06-29 GMT+08:00

算子

**

Netezza语法

迁移后语法

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语法

迁移后语法

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