odbtools/odbctest/mql/test/icbctest/4update.mql

select class,id,vtime,alertkey from /m3event/devops/alerts_status where name='7872419216861007235'
/**
output()
**/
;

update /m3event/devops/alerts_status set alertkey='test alert key' where name='7872419216861007235'
;

select class,id,vtime,alertkey from /m3event/devops/alerts_status where name='7872419216861007235'
/**
output()
**/
;

update /m3event/devops/alerts_status set alertkey=NULL where name='7872419216861007235'
;

select class,id,vtime,alertkey from /m3event/devops/alerts_status where name='7872419216861007235'
/**
output()
**/
;