MSCEWI3018

Snowflake does not support occurrence parameter.

This issue has been deprecated since SnowConvert for Oracle 0.8.13. For more information check MSCEWI3079

Severity

Medium

Description

The INSTR functions do not support the fourth parameter that is the one for the occurrence value specification. The Snowflake Position equivalent function does not support the occurrence parameter and then the value is removed and this message is being added.

Example Code

Input Code:

CREATE TABLE TABLE1
(
 COL1 NUMBER DEFAULT INSTRB('CORPORATE FLOOR','OR', 3),
 COL2 NUMBER DEFAULT INSTRC('CORPORATE FLOOR','OR'),
 COL3 NUMBER DEFAULT INSTR2('CORPORATE FLOOR','OR', 3, 2),
 COL4 NUMBER DEFAULT INSTR4('CORPORATE FLOOR','OR', 3, 2)
);

Output Code:

CREATE OR REPLACE TABLE MYDB.PUBLIC.TABLE1 (
COL1 NUMBER (38,19) DEFAULT POSITION('OR', 'CORPORATE FLOOR', 3),
COL2 NUMBER (38,19) DEFAULT POSITION('OR', 'CORPORATE FLOOR'),
COL3 NUMBER (38,19) DEFAULT POSITION('OR', 'CORPORATE FLOOR', 3) /*** MSC-ERROR - MSCEWI3018 - SNOWFLAKE DOES NOT SUPPORT OCCURRENCE PARAMETER ***/,
COL4 NUMBER (38,19) DEFAULT POSITION('OR', 'CORPORATE FLOOR', 3) /*** MSC-ERROR - MSCEWI3018 - SNOWFLAKE DOES NOT SUPPORT OCCURRENCE PARAMETER ***/);

Recommendations