{"id":4874,"date":"2025-08-08T17:39:59","date_gmt":"2025-08-08T08:39:59","guid":{"rendered":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/?p=4874"},"modified":"2025-08-08T17:40:16","modified_gmt":"2025-08-08T08:40:16","slug":"db2%e3%81%ae%e9%95%b7%e6%99%82%e9%96%93%e5%ae%9f%e8%a1%8c%e3%82%af%e3%82%a8%e3%83%aa%e3%81%ab%e9%96%a2%e3%81%99%e3%82%8b%e6%97%a2%e7%9f%a5%e3%81%ae%e4%b8%8d%e5%85%b7%e5%90%88","status":"publish","type":"post","link":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/?p=4874","title":{"rendered":"DB2\u306e\u9577\u6642\u9593\u5b9f\u884c\u30af\u30a8\u30ea\u306b\u95a2\u3059\u308b\u65e2\u77e5\u306e\u4e0d\u5177\u5408"},"content":{"rendered":"<p>DB2\u3067\u306e\u9577\u6642\u9593\u5b9f\u884c\u30af\u30a8\u30ea\u306e\u76e3\u8996\u306b\u304a\u3044\u3066\u3001\u4ee5\u4e0b\uff12\u70b9\u306e\u4e0d\u5177\u5408\u3092\u78ba\u8a8d\u3057\u3066\u304a\u308a\u307e\u3059\u3002<\/p>\n<ul>\n<li>1\u70b9\u76ee\uff1aCLOB\u578b\u306e\u51e6\u7406\u306b\u95a2\u3059\u308b\u554f\u984c<\/li>\n<li>2\u70b9\u76ee\uff1a\u91cd\u8907\u884c\u633f\u5165\u306b\u95a2\u3059\u308b\u554f\u984c<\/li>\n<\/ul>\n<h3>1\u70b9\u76ee\uff1aCLOB\u578b\u306e\u51e6\u7406\u306b\u95a2\u3059\u308b\u554f\u984c<\/h3>\n<h4>\u6982\u8981<\/h4>\n<p>DB2\u306e\u9577\u6642\u9593\u5b9f\u884c\u30af\u30a8\u30ea\u304b\u3089\u8fd4\u3055\u308c\u308b\"QUERY\"\u30ab\u30e9\u30e0\u306fCLOB\u578b\u306b\u3082\u304b\u304b\u308f\u3089\u305a\u3001\u88fd\u54c1\u4e0a\u3067STRING\u578b\u3068\u3057\u3066\u51e6\u7406\u3055\u308c\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u539f\u56e0\u3067\u51e6\u7406\u4e2d\u306b\u4f8b\u5916\uff08\u30a8\u30e9\u30fc\uff09\u304c\u767a\u751f\u3059\u308b\u3002<\/p>\n<h4>\u8a72\u5f53\u30d3\u30eb\u30c9<\/h4>\n<p>\uff5e174304\uff082025\u5e746\u6708\u30ea\u30ea\u30fc\u30b9\u30d3\u30eb\u30c9\uff09<\/p>\n<h4>\u5bfe\u5fdc\u65b9\u6cd5<\/h4>\n<p>\u4eca\u5f8c\u306e\u30ea\u30ea\u30fc\u30b9\u306b\u3066\u4fee\u6b63\u3092\u4e88\u5b9a\u3057\u3066\u304a\u308a\u307e\u3059\uff08\u30ea\u30ea\u30fc\u30b9\u30d3\u30eb\u30c9\u306f\u672a\u5b9a\uff09\u3002<\/p>\n<p><a href=\"https:\/\/www.manageengine.jp\/support\/purchased.html\" target=\"_blank\" rel=\"noopener\">\u6280\u8853\u30b5\u30dd\u30fc\u30c8\u7a93\u53e3<\/a>\u306b\u3066\u30d1\u30c3\u30c1\u3092\u63d0\u4f9b\u3044\u305f\u3057\u307e\u3059\u306e\u3067\u3001\u3054\u5165\u7528\u306e\u969b\u306f\u3054\u9023\u7d61\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>&nbsp;<\/p>\n<h3>2\u70b9\u76ee\uff1a\u91cd\u8907\u884c\u633f\u5165\u306b\u95a2\u3059\u308b\u554f\u984c<\/h3>\n<h4>\u6982\u8981<\/h4>\n<p>\u53ce\u96c6\u3055\u308c\u305f\u9577\u6642\u9593\u5b9f\u884c\u30af\u30a8\u30ea\u306b\u304a\u3044\u3066\u3001\u3059\u3067\u306b\u540c\u3058\u884c\u304c\u5b58\u5728\u3057\u3066\u3044\u308b\u5834\u5408<br \/>\n\"row already exists\"\u3068\u3044\u3046\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u3002<\/p>\n<h4>\u8a72\u5f53\u30d3\u30eb\u30c9<\/h4>\n<p>\uff5e174304\uff082025\u5e746\u6708\u30ea\u30ea\u30fc\u30b9\u30d3\u30eb\u30c9\uff09<\/p>\n<h4>\u5bfe\u5fdc\u65b9\u6cd5<\/h4>\n<p>\u4eca\u5f8c\u306e\u30ea\u30ea\u30fc\u30b9\u306b\u3066\u4fee\u6b63\u3092\u4e88\u5b9a\u3057\u3066\u304a\u308a\u307e\u3059\uff08\u30ea\u30ea\u30fc\u30b9\u30d3\u30eb\u30c9\u306f\u672a\u5b9a\uff09\u3002<\/p>\n<p><a href=\"https:\/\/www.manageengine.jp\/support\/purchased.html\" target=\"_blank\" rel=\"noopener\">\u6280\u8853\u30b5\u30dd\u30fc\u30c8\u7a93\u53e3<\/a>\u306b\u3066\u30d1\u30c3\u30c1\u3092\u63d0\u4f9b\u3044\u305f\u3057\u307e\u3059\u306e\u3067\u3001\u3054\u5165\u7528\u306e\u969b\u306f\u3054\u9023\u7d61\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DB2\u3067\u306e\u9577\u6642\u9593\u5b9f\u884c\u30af\u30a8\u30ea\u306e\u76e3\u8996\u306b\u304a\u3044\u3066\u3001\u4ee5\u4e0b\uff12\u70b9\u306e\u4e0d\u5177\u5408\u3092\u78ba\u8a8d\u3057\u3066\u304a\u308a\u307e\u3059\u3002 1\u70b9\u76ee\uff1aCLOB\u578b\u306e\u51e6\u7406\u306b\u95a2\u3059\u308b\u554f\u984c 2\u70b9\u76ee\uff1a\u91cd\u8907\u884c\u633f\u5165\u306b\u95a2\u3059\u308b\u554f\u984c \u2026 <a href=\"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/?p=4874\" class=\"more\">\uff3b\u7d9a\u304d\u3092\u8aad\u3080\uff3d<\/a><\/p>\n","protected":false},"author":47,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"no","_lmt_disable":"","footnotes":""},"categories":[7],"tags":[],"class_list":["post-4874","post","type-post","status-publish","format-standard","hentry","category-4-knownissue-apm"],"modified_by":"manami","_links":{"self":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/index.php?rest_route=\/wp\/v2\/posts\/4874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/index.php?rest_route=\/wp\/v2\/users\/47"}],"replies":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4874"}],"version-history":[{"count":3,"href":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/index.php?rest_route=\/wp\/v2\/posts\/4874\/revisions"}],"predecessor-version":[{"id":4877,"href":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/index.php?rest_route=\/wp\/v2\/posts\/4874\/revisions\/4877"}],"wp:attachment":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/Applications_Manager\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}