MSCEWI3027
ROWNUM is not supported.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Medium
Description
ROWNUM statement is not currently supported.
Example Code
Input Code:
SELECT ROWNUM FROM TABLE1;
Output Code:
SELECT
/*** MSC-ERROR - MSCEWI3027 - ROWNUM NOT SUPPORTED ***/
ROWNUM_UDF('ROWNUM')
FROM PUBLIC.TABLE1;
Recommendations
ROWNUM is converted to a user-defined function (UDF), so you can modify it to emulate the behavior of the statement.
If you need more support, you can email us at [email protected]
Last updated