Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> SQL Syntax Migration Reference> Netezza Syntax Migration> Operator
Operator
**
| Netezza Syntax | Syntac After Migration |
|---|---|
V_Out := V_Out + v_J * ( v_N ** v_K ) ; | V_Out := V_Out + v_J * ( v_N ^ v_K ) ; |
NOTNULL and ISNULL
| Netezza Syntax | Syntac After Migration |
|---|---|
CASE WHEN ((A1.EXCEPT_OFF_SEQU_NO NOTNULL) AND (A2.LOG_SEQU_NO ISNULL)) THEN 0 ELSE 1 END AS FLG | 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
Last Article: System Functions
Next Article: DML
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.