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]