SSC-EWI-PG0014
Snowflake scripting cursors do not support fetch orientation
Last updated
Snowflake scripting cursors do not support fetch orientation
Last updated
Medium
In Snowflake, the statement always fetches the next row in the cursor. When transforming the code, SnowConvert will transform cursor orientations that are equivalent to a FETCH NEXT as they are functionally equivalent in Snowflake, namely:
FETCH NEXT
FETCH FORWARD
FETCH RELATIVE 1
FETCH
(no orientation specified)
Any other orientation is unsupported and the FETCH statement will be marked with this EWI to reflect that.
If you need more support, you can email us at