How to insert a literal ‘ into IBM Netcool/OMNIbus ObjectServer
$ nco_sql -user netcool1> update custom.filterclauses set sqlclause = ‘EventClass = \’Tech Event\” where clauseid = 262> go(1 row affected) This detail seems to be missing from the manual and is somewhat hard to find otherwise. Other variants like doubling ‘ or concatenating a char(39) function will not work.
