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

\\