SET ECHO ON
SET LINESIZE 200

WHENEVER OSERROR EXIT 127
WHENEVER SQLERROR EXIT 127

DELETE
FROM
    KK_T_BLOCKING_INFO KK3212
WHERE
    KK3212.INCIDENT_YMD <= TO_CHAR(TO_DATE('&1', 'YYYYMMDD') - 
    (SELECT
     ZM0311.SYS_PARAM_SETTE_VALUE_1
    FROM ZM_M_SYS_PARAM_KNRI ZM0311
    WHERE ZM0311.SYS_PARAM_BUNRUI_CD = 'BLOCKING_INFO'
      AND ZM0311.SYS_PARAM_ID = 'BLOCKING_HOJI_PRD'
      AND ZM0311.SYS_PARAM_TSTAYMD   <= '&1'
      AND ZM0311.SYS_PARAM_TENDYMD   >= '&1'
      AND ZM0311.MK_FLG              = '0'
    )
    , 'YYYYMMDD')
;

COMMIT ;

EXIT 0

quit