This is a deprecated version of the SnowConvert documentation, please visit the official site .
Severity
High
Description
This error appears when there is an unexpected end of the statement in the source code
Example Code
Input Code:
CREATE VOLATILE SET TABLE VOLATILETABLE
(
COL1 INTEGER,
COL2 INTEGER,
COL3 INTEGER
)
ON COMMIT PRESERVE ROWS;
UPDATE TABLE2 as T2
SET T2.COL1 + VOLATILETABLE.COL1
WHERE T2.COL2 = VOLATILETABLE.COL2
AND T2.COL3 = VOLATILETABLE.COL3
AND T2.COL4 = ( SELECT MAX(T3.COL1)
FROM
TABLE3 T3
WHERE T3.COL1 = T2.COL1);
Output Code:
/*** MSC-WARNING - MSCEWI2015 - SET TABLE FUNCTIONALITY NOT SUPPORTED ***/
CREATE TEMPORARY TABLE PUBLIC.VOLATILETABLE
(
COL1 INTEGER,
COL2 INTEGER,
COL3 INTEGER
);
UPDATE PUBLIC.TABLE2 AS T2 SET --** MSC-ERROR - MSCEWI1012 - UNEXPECTED END OF STATEMENT. PLEASE CHECK THE LINE 9 OF ORIGINAL SOURCE CODE. **T2.COL1 + VOLATILETABLE.COL1 FROM VOLATILETABLE AS PUBLIC_VOLATILETABLE
WHERE T2.COL2 = PUBLIC_VOLATILETABLE.COL2
AND T2.COL3 = PUBLIC_VOLATILETABLE.COL3
AND T2.COL4 = (SELECT
MAX(T3.COL1)
FROM PUBLIC.TABLE3 T3
WHERE T3.COL1 = T2.COL1);
Recommendation
Check if the source code is incomplete or if the statement that is being converted ends correctly.
