{"id":2172,"date":"2026-08-31T21:58:59","date_gmt":"2026-08-31T19:58:59","guid":{"rendered":"https:\/\/www.netnea.com\/cms\/?p=2172"},"modified":"2026-08-31T21:58:59","modified_gmt":"2026-08-31T19:58:59","slug":"how-to-insert-a-literal-into-ibm-netcool-omnibus-objectserver","status":"publish","type":"post","link":"https:\/\/www.netnea.com\/cms\/2026\/08\/31\/how-to-insert-a-literal-into-ibm-netcool-omnibus-objectserver\/","title":{"rendered":"How to insert a literal &#8216; into IBM Netcool\/OMNIbus ObjectServer"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><code>$ nco_sql -user netcool<br>1> update custom.filterclauses set sqlclause = 'EventClass = \\'Tech Event\\'' where clauseid = 26<br>2> go<br>(1 row affected)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This detail seems to be missing from the manual and is somewhat hard to find otherwise. Other variants like doubling &#8216; or concatenating a char(39) function will not work.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>$ nco_sql -user netcool1> update custom.filterclauses set sqlclause = &#8216;EventClass = \\&#8217;Tech Event\\&#8221; 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 &#8216; or concatenating a char(39) function will not work.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44,3],"tags":[8],"class_list":["post-2172","post","type-post","status-publish","format-standard","category-databases","category-nms","tag-netcool","czr-hentry"],"_links":{"self":[{"href":"https:\/\/www.netnea.com\/cms\/wp-json\/wp\/v2\/posts\/2172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.netnea.com\/cms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.netnea.com\/cms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.netnea.com\/cms\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.netnea.com\/cms\/wp-json\/wp\/v2\/comments?post=2172"}],"version-history":[{"count":3,"href":"https:\/\/www.netnea.com\/cms\/wp-json\/wp\/v2\/posts\/2172\/revisions"}],"predecessor-version":[{"id":2176,"href":"https:\/\/www.netnea.com\/cms\/wp-json\/wp\/v2\/posts\/2172\/revisions\/2176"}],"wp:attachment":[{"href":"https:\/\/www.netnea.com\/cms\/wp-json\/wp\/v2\/media?parent=2172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.netnea.com\/cms\/wp-json\/wp\/v2\/categories?post=2172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.netnea.com\/cms\/wp-json\/wp\/v2\/tags?post=2172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}