MSCEWI5009

POSITIONED STATEMENT IS NOT SUPPORTED.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

Snowflake does not support the use of cursors as part of the Delete statement and Update statement. If the statement is migrated partially, we will get rid of the where clause in which the cursor is forming part, making it dangerous to delete or update the whole table. For this reason, the complete statement will be commented out with this EWI.

Code example

DB2

Delete statement

DELETE FROM table1 
WHERE CURRENT OF cursor1

Update statement

UPDATE table1
     SET col1 = 1
     WHERE CURRENT OF cursor1

Snowflake

Delete statement

-- ** MSC-ERROR - MSCEWI5009 - POSITIONED DELETE IS NOT SUPPORTED. **
--DELETE FROM table1
--WHERE CURRENT OF cursor1

Update statement

-- ** MSC-ERROR - MSCEWI5009 - POSITIONED UPDATE IS NOT SUPPORTED. **
--UPDATE table1
--     SET col1 = 1
--     WHERE CURRENT OF cursor1

Recommendations

• If you need more support, you can email us at [e-mail]