MSCEWI2040

The format in a table is not supported.

Severity
Low
Description
The specified format is not supported.
Example Code
Input Code:
CREATE TABLE T_2040
(
    C1 VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC FORMAT 'X(50)',
    C2 VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC FORMAT 'X(75)'
);
Output Code:
CREATE TABLE PUBLIC.T_2040
(
    C1 VARCHAR(255) COLLATE 'en-ci' /*** MSC-WARNING - MSCEWI2040 - FORMAT 'X(50)' NOT SUPPORTED ***/,
    C2 VARCHAR(255) COLLATE 'en-ci' /*** MSC-WARNING - MSCEWI2040 - FORMAT 'X(75)' NOT SUPPORTED ***/
);
Recommendations
No additional user actions are required.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
For INTEGER FORMAT '99:99:99' a workaround is to use TIME(6) in Snowflake.

MSCEWI2039

MSCEWI2041

Last modified 3mo ago