__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
WHERE SCRIPT_FILE_NAME = 'FW44022_POSTDATA_OUAF-17513.SQL'
   AND END_DTTM IS NOT NULL
/
__THEN__
__EXIT__
__ENDIF__


UPDATE  CI_BATCH_CTRL_P_L BCPL SET  BCPL.DESCRLONG =    CASE      WHEN TRIM(BCPL.DESCRLONG) IS NOT NULL THEN BCPL.DESCRLONG || ' Enter the value "suppress" to suppress the root element altogether.'      WHEN TRIM(BCPL.DESCRLONG) IS NULL THEN 'Enter the value "suppress" to suppress the root element altogether.'    END WHERE  EXISTS (    SELECT      'X'    FROM      CI_BATCH_CTRL BC,      CI_BATCH_CTRL_P BCP    WHERE      BC.PROGRAM_NAME = 'com.splwg.base.domain.batch.pluginDriven.PluginDrivenExtractProcess'      AND BC.BATCH_CD <> 'F1-PDBEX'      AND BC.BATCH_CD = BCP.BATCH_CD      AND BCP.BATCH_PARM_NAME = 'xmlRootName'      AND BCP.BATCH_CD = BCPL.BATCH_CD      AND BCP.SEQ_NUM = BCPL.SEQ_NUM      AND BCPL.LANGUAGE_CD = 'ENG' AND BCPL.DESCRLONG NOT LIKE '%suppress%' )
/