New submission from z06steve:
fails to replace last occurrence of string v_wofstgvw, reproduced in 3.2.3,
3.2.4 and 3.3.1
a='''
-- V_INT_CTRC_ENTRY_DATE
REPLACE VIEW V_WOFSTGVW.V_INT_CTRC_ENTRY_DATE AS LOCKING ROW FOR ACCESS
SELECT
D.DY DY,
D.DW_CRRT_FL CURRENT_FLAG,
D.MTH CURRENT_MTH,
(CAST(D.DY AS DATE) - EXTRACT(DAY FROM (CAST( D.DY AS DATE)))+1)
CURRENT_MTH_BEG_DT,
ADD_MONTHS ((CAST(D.DY AS DATE) - EXTRACT(DAY FROM (CAST( D.DY AS
DATE)))+1) , 1) - 1 CURRENT_MTH_END_DT,
D.WOFC_MTH_END_FLG CURRENT_MTH_END_FLG,
D.WOFC_QTR_END_FLG CURRENT_QTR_END_FL,
D.YR CURRENT_YEAR,
((D.YR||'01/01')(DATE)) CURRENT_YEAR_BEG_DT ,
((D.YR||'12/31')(DATE)) CURRENT_YEAR_END_DT ,
D.WOFC_YR_END_FLG CURRENT_YEAR_END_FL,
D.HDAY_FLG HOLIDAY_FLG,
CAST(ADD_MONTHS (CASE WOFC_MTH_END_FLG
WHEN 'Y'
THEN WOFCO_FRST_DY_MTH
ELSE WOFCO_BEGIN_MTH_DT
END,
-1)AS CHAR(7)) PREV_REP_MTH,
ADD_MONTHS (CASE WOFC_MTH_END_FLG
WHEN 'Y'
THEN WOFCO_FRST_DY_MTH
ELSE WOFCO_BEGIN_MTH_DT
END,
-1
) PREV_REP_MTH_BEG_DT,
ADD_MONTHS (CASE WOFC_MTH_END_FLG
WHEN 'Y'
THEN D.DY
ELSE D.WOFCO_MTH_END_DT
END,
-1
) PREV_REP_MTH_END_DT
,
D.PREV_MTH PRIOR_MTH,
PSETM.PRIOR_SET_CURRENT_MTH,
PSETM.PRIOR_SET_CURRENT_MTH_BGN_DT,
PSETM.PRIOR_SET_CURRENT_MTH_END_DT,
PREPSETM.PRIOR_SET_REP_MTH,
PREPSETM.PRIOR_SET_REP_MTH_BGN_DT,
PREPSETM.PRIOR_SET_REP_MTH_END_DT,
CASE WOFC_MTH_END_FLG
WHEN 'Y'
THEN MTH
ELSE PREV_MTH
END REP_MTH,
CASE WOFC_MTH_END_FLG
WHEN 'Y'
THEN WOFCO_FRST_DY_MTH
ELSE WOFCO_BEGIN_MTH_DT
END REP_MTH_BEG_DT,
CASE WOFC_MTH_END_FLG
WHEN 'Y'
THEN D.DY
ELSE D.WOFCO_MTH_END_DT
END REP_MTH_END_DT,
CASE WOFC_MTH_END_FLG
WHEN 'Y'
THEN ADD_MONTHS (D.WOFCO_FRST_DY_MTH,
12
)
ELSE ADD_MONTHS (D.WOFCO_BEGIN_MTH_DT, 12)
END REP_MTH_NEXT_YEAR_BEG_DT,
CASE WOFC_MTH_END_FLG
