La requête suivante

select CO_TYPE_EVT, count(*) from TBGENOT
where
DT_MAJ = '2018-04-01'
and CO_UTIL_MAJ = 'JYECAJA1 PECAMB02'
and TS_PEC_NOTI is not null
group by CO_TYPE_EVT

retourne :
CO_TYPE_EVT Nb
EAUE0007 690274
EAUE0056 2
EREN0013 3038
EREN0019 70
EREN0035 97

on met TS_PEC_NOTI a null

update TBGENOT
set TS_PEC_NOTI is null
where
DT_MAJ = '2018-04-01'
and CO_UTIL_MAJ = 'JYECAJA1 PECAMB02'

et on relance le JYECAJA1