Links

MSCEWI1034

Format removed.

Severity

Low

Description

This warning appears when the format of the column used in a CAST function is removed.

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') + 1 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 - MSCEWI1034 - FORMAT 'MMM-YYYY' REMOVED. ***/ + 1 AS NPT_MONTH
FROM DADSD01.PUBLIC.TADS_FACT_ADP_PROD_MVMT_DETL;

Recommendation