Links

MSCEWI1033

Format removed, semantic information not found.

Severity

Low

Description

This warning appears when a column used in a CAST function with a specific output format was not found in the source code.

Example Code

Input Code:

REPLACE VIEW DAFFD01.VAFFL_CAR_ADEMPAS_MVMT_DETL AS LOCKING ROW FOR ACCESS
SEL DATA_SRCE_NAME, DAY_DATE(FORMAT 'MMM-YYYY')(CHAR(8)) AS NPT_MONTH
FROM DADSD01.TADS_FACT_ADP_PROD_MVMT_DETL;

Output Code:

CREATE OR REPLACE VIEW DAFFD01.PUBLIC.VAFFL_CAR_ADEMPAS_MVMT_DETL
AS
SELECT
DATA_SRCE_NAME,
DAY_DATE /*** MSC-WARNING - MSCEWI1033 - FORMAT 'MMM-YYYY' REMOVED, SEMANTIC INFORMATION NOT FOUND. ***/::CHAR(8) AS NPT_MONTH
FROM DADSD01.PUBLIC.TADS_FACT_ADP_PROD_MVMT_DETL;

Recommendation

  • Make sure all the dependencies(tables and views) related to the procedure statement are being migrated.
  • 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.