MSCEWI2027

Period data type converted to varchar, but transaction time not supported.

Severity

Low

Description

This warning appears when a table column is of PERIOD data type. This data type will be converted to VARCHAR . If the column has TEMPORAL attributes like VALIDTIME or TRANSACTIONTIME they should be removed as well.

Code Example

Input Code:

CREATE MULTISET TABLE SAMPLE_TABLE
(
COL1 PERIOD(TIMESTAMP(6) WITH TIME ZONE) NOT NULL AS TRANSACTIONTIME
);

Output Code:

CREATE TABLE PUBLIC.SAMPLE_TABLE
(
COL1 VARCHAR(68) NOT NULL COMMENT 'PERIOD(TIMESTAMP(6) WITH TIME ZONE)' /*** MSC-WARNING - MSCEWI2027 - PERIOD DATA TYPE "PERIOD(TIMESTAMP(6) WITH TIME ZONE)" CONVERTED TO VARCHAR , BUT TRANSACTIONTIME NOT SUPPORTED ***/
);

Recommendations

  • Take a look if the output code has functional equivalence with the original code.

  • 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.