{"id":619,"date":"2015-03-13T02:04:08","date_gmt":"2015-03-13T11:04:08","guid":{"rendered":"http:\/\/blog.box.kr\/?p=619"},"modified":"2015-03-13T02:04:08","modified_gmt":"2015-03-13T11:04:08","slug":"%ed%8e%8cibmcli-driver-sql0418n-sqlstate42610","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=619","title":{"rendered":"[\ud38c][IBM][CLI Driver] SQL0418N SQLSTATE=42610"},"content":{"rendered":"<div class=\"msgnum\"><strong>\uac1c\uad04 :<\/strong>\u00a0[IBM][CLI Driver] SQL0418N\u00a0SQLSTATE=42610\n<\/div>\n<div class=\"msgnum\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\uba85\ub839\ubb38\uc5d0 \uc720\ud6a8\ud558\uc9c0 \uc54a\uc740 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\uac00 \uc0ac\uc6a9\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\n<\/div>\n<div class=\"msg\">\n<div class=\"msgitem\">\n<div class=\"msgitemtitle\">\n<\/div>\n<div class=\"msgitemtitle\"><strong>\uc6d0\uc778:<\/strong>\n<\/div>\n<p class=\"msgitem\">\ub2e4\uc74c \uacbd\uc6b0\uc5d0\ub294 \uc720\ud615\uc774 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>SELECT \ubaa9\ub85d\uc5d0\uc11c<\/li>\n<li>\ub0a0\uc9dc \uc2dc\uac04 \uc0b0\uc220 \uc5f0\uc0b0\uc758 \uc720\uc77c\ud55c \uc778\uc218\ub85c<\/li>\n<li>\uacbd\uc6b0\uc5d0 \ub530\ub77c \uc2a4\uce7c\ub77c \ud568\uc218\uc758 \uc720\uc77c\ud55c \uc778\uc218\ub85c<\/li>\n<li>ORDER BY\uc808\uc5d0\uc11c \uc815\ub82c \ud0a4\ub85c<\/li>\n<\/ul>\n<p class=\"msgitem\">\ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\uc900\ube44\ub41c \uba85\ub839\ubb38\uc774 \uc544\ub2cc \uba85\ub839\ubb38\uc5d0\uc11c<\/li>\n<li>CREATE VIEW\ubb38\uc758 fullselect\uc5d0\uc11c<\/li>\n<li>CREATE TRIGGER\ubb38\uc758 \ud2b8\ub9ac\uac70 \uc870\uce58\uc5d0\uc11c<\/li>\n<li>DB2 Query Patroller\uac00 \ucea1\ucc98\ud558\ub294 \ucffc\ub9ac\uc5d0\uc11c<\/li>\n<\/ul>\n<p class=\"msgitem\">\uba85\ub839\ubb38\uc744 \ucc98\ub9ac\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"msgitem\">\n<div class=\"msgitemtitle\">\n<\/div>\n<div class=\"msgitemtitle\"><strong>\uc0ac\uc6a9\uc790\u3000\uc751\ub2f5<\/strong>:\n<\/div>\n<p class=\"msgitem\">\n<p class=\"msgitem\">\uba85\ub839\ubb38\uc758 \uad6c\ubb38\uc744 \uc815\uc815\ud558\uc2ed\uc2dc\uc624. \uc720\ud615\uc774 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\uac00 \ud5c8\uc6a9\ub418\uc9c0 \uc54a\ub294 \uacbd\uc6b0, \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\uc5d0 \ub370\uc774\ud130 \uc720\ud615\uc744 \uc81c\uacf5\ud558\ub824\uba74 CAST \uc2a4\ud399\uc744 \uc0ac\uc6a9\ud558\uc2ed\uc2dc\uc624.<\/p>\n<p class=\"msgitem\"><span class=\"bold\">sqlcode\u00a0<\/span>: -418<\/p>\n<p class=\"msgitem\"><span class=\"bold\">sqlstate\u00a0<\/span>: 42610<\/p>\n<\/div>\n<\/div>\n<div class=\"msgitem\">\n<p class=\"msgitem\">\n<p class=\"msgitem\">\ud55c\ub9c8\ub514\ub85c ?\ubd80\ubd84\uc744 cast\ucc98\ub9ac\ub97c \ud574\uc918\uc57c \ud55c\ub2e4\ub294 \ub9d0<\/p>\n<p class=\"msgitem\">\uc608\ub97c \ub4e0\uba74 CAST( ? AS VARCHAR(12)) \ub85c \ucc98\ub9ac \ud558\uba74\ub41c\ub2e4<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\uac1c\uad04 :\u00a0[IBM][CLI Driver] SQL0418N\u00a0SQLSTATE=42610 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\uba85\ub839\ubb38\uc5d0 \uc720\ud6a8\ud558\uc9c0 \uc54a\uc740 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\uac00 \uc0ac\uc6a9\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc6d0\uc778: \ub2e4\uc74c \uacbd\uc6b0\uc5d0\ub294 \uc720\ud615\uc774 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. SELECT \ubaa9\ub85d\uc5d0\uc11c \ub0a0\uc9dc \uc2dc\uac04 \uc0b0\uc220 \uc5f0\uc0b0\uc758 \uc720\uc77c\ud55c \uc778\uc218\ub85c \uacbd\uc6b0\uc5d0 \ub530\ub77c \uc2a4\uce7c\ub77c \ud568\uc218\uc758 \uc720\uc77c\ud55c \uc778\uc218\ub85c ORDER BY\uc808\uc5d0\uc11c \uc815\ub82c \ud0a4\ub85c \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc900\ube44\ub41c \uba85\ub839\ubb38\uc774 \uc544\ub2cc \uba85\ub839\ubb38\uc5d0\uc11c CREATE VIEW\ubb38\uc758 fullselect\uc5d0\uc11c CREATE TRIGGER\ubb38\uc758 \ud2b8\ub9ac\uac70 \uc870\uce58\uc5d0\uc11c DB2 Query Patroller\uac00 \ucea1\ucc98\ud558\ub294 \ucffc\ub9ac\uc5d0\uc11c \uba85\ub839\ubb38\uc744 \ucc98\ub9ac\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\u3000\uc751\ub2f5: \uba85\ub839\ubb38\uc758 \uad6c\ubb38\uc744 \uc815\uc815\ud558\uc2ed\uc2dc\uc624. \uc720\ud615\uc774 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\uac00 \ud5c8\uc6a9\ub418\uc9c0 \uc54a\ub294 \uacbd\uc6b0, \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\uc5d0 \ub370\uc774\ud130 \uc720\ud615\uc744 \uc81c\uacf5\ud558\ub824\uba74 CAST \uc2a4\ud399\uc744 \uc0ac\uc6a9\ud558\uc2ed\uc2dc\uc624. sqlcode\u00a0: -418 sqlstate\u00a0: 42610 \ud55c\ub9c8\ub514\ub85c ?\ubd80\ubd84\uc744 cast\ucc98\ub9ac\ub97c \ud574\uc918\uc57c \ud55c\ub2e4\ub294 \ub9d0 \uc608\ub97c \ub4e0\uba74 CAST( ? AS VARCHAR(12)) \ub85c \ucc98\ub9ac \ud558\uba74\ub41c\ub2e4<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[12,5,7],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-9Z","jetpack-related-posts":[{"id":93,"url":"https:\/\/blog.box.kr\/?p=93","url_meta":{"origin":619,"position":0},"title":"shift, ctrl (\uc26c\ud504\ud2b8, \ucee8\ud2b8\ub864)\ud0a4 \ud074\ub9ad\ud558\uba74 \uacbd\uace0\uba54\uc138\uc9c0 \ub744\uc6b0\uae30","date":"2014-06-12","format":false,"excerpt":"shift, ctrl (\uc26c\ud504\ud2b8, \ucee8\ud2b8\ub864)\ud0a4 \ud074\ub9ad\ud558\uba74 \uacbd\uace0\uba54\uc138\uc9c0 \ub744\uc6b0\uae30 <script language=\"JavaScript\"> < !-- www.tagin.net function click() { if((event.ctrlKey) || (event.shiftKey)) { alert('\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.'); } } document.ommousedown=click; document.omkeydown=click; --> < \/script>","rel":"","context":"In &quot;javascript&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":701,"url":"https:\/\/blog.box.kr\/?p=701","url_meta":{"origin":619,"position":1},"title":"TOMCAT Virtual Host\ub9cc\ub4e4\uae30","date":"2015-04-15","format":false,"excerpt":"1.\u00a0${catalina.home}\/conf\/server.xml \ud654\uc77c\uc744 \uc5f4\uc5b4\uc11c \uc544\ub798\uc640 \uac19\uc774 \ubcc0\uacbd <Engine name=\"Catalina\"defaultHost=\"localhost\"debug=\"0\"> To <Engine name=\"Catalina\"defaultHost=\"www.example.com\"debug=\"0\"> ** \uc5ec\uae30\uc11c \uc9c0\uc815\ud55c defaultHost\ub294 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\ub85c \uc811\uc18d ( ie. IP\ub85c \uc811\uc18d \ub4f1 )\uc77c\ub54c \uae30\ubcf8\uc73c\ub85c \ubcf4\uc77c \uc0ac\uc774\ud2b8 2. \uc0ac\uc6a9\ud560 \uac00\uc0c1 \ud638\uc2a4\ud2b8 \uc815\ubcf4\ub97c \ucd94\uac00 <Host name=\"localhost\"debug=\"0\"appBase=\"webapps\" \u00a0unpackWARs=\"true\"autoDeploy=\"true\" \u00a0xmlValidation=\"false\"xmlNamespaceAware=\"false\"> To \u00a0 \u00a0<Host name=\"www.example.com\"debug=\"0\"appBase=\"public\" \u00a0 \u00a0 \u00a0 \u00a0unpackWARs=\"true\"autoDeploy=\"true\" \u00a0 \u00a0 \u00a0 \u00a0xmlValidation=\"false\"xmlNamespaceAware=\"false\">\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":687,"url":"https:\/\/blog.box.kr\/?p=687","url_meta":{"origin":619,"position":2},"title":"[\ud38c]MariaDB \uc124\uc815 \ud30c\uc77c my.cnf","date":"2015-04-13","format":false,"excerpt":"http:\/\/www.programkr.com\/blog\/MUDM5ADMwYT2.html \u00a0 \u00a0 # MariaDB database server configuration file. # # You can copy this file to one of: # - \"\/etc\/mysql\/my.cnf\" to set global options, # - \"~\/.my.cnf\" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":783,"url":"https:\/\/blog.box.kr\/?p=783","url_meta":{"origin":619,"position":3},"title":"[scrap] \ud154\ub808\uadf8\ub7a8(Telegram)\uc73c\ub85c \uc11c\ubc84 \ubaa8\ub2c8\ud130\ub9c1\ud558\uae30","date":"2015-05-13","format":false,"excerpt":"http:\/\/truefeel.tistory.com\/224 \u00a0 \uba54\uc2e0\uc800 \uac80\uc5f4\ub85c '\ud154\ub808\uadf8\ub7a8(Telegram)' \uad11\ud48d\uc774 \ubd88\uace0 \uc788\ub2e4. \uac1c\uc778\uc801\uc73c\ub85c \uce74\ud1a1\uc744 \uc790\uc8fc \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc544, \ud154\ub808\uadf8\ub7a8\uc774 \uc808\uc2e4(?)\ud558\uac8c \ud544\uc694\ud558\uc9c0 \uc54a\ub2e4. \ud558\uc9c0\ub9cc \ud154\ub808\uadf8\ub7a8\uc744 \uc0ac\uc6a9\ud574\uc57c\ud560 \uc774\uc720\uac00 \uc0dd\uacbc\ub2e4. \ud154\ub808\uadf8\ub7a8\uc774 \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 CLI\ub97c \uc81c\uacf5\ud558\uace0 \uc788\uace0, lua\ub098 python\uc73c\ub85c \uc190\uc27d\uac8c \uba54\uc2e0\uc800\uc640 \uc5f0\ub3d9\ud560 \uc218 \uc788\ub2e4. \uadf8\ub798\uc11c \ud154\ub808\uadf8\ub7a8\uc6a9 lua\uc2a4\ud06c\ub9bd\ud2b8\ub97c \ub9cc\ub4e4\uc5b4\uc11c \uc11c\ubc84 \uc0c1\ud0dc\ub97c \ud3f0\uc5d0\uc11c \ubc1b\uc544\ubcfc \uc218 \uc788\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ud2b9\uc815\u2026","rel":"","context":"In &quot;\uae30\uc220&quot;","img":{"alt_text":"telegram-cli \u00ec\u008b\u00a4\u00ed\u0096\u0089\u00ed\u0099\u0094\u00eb\u00a9\u00b4","src":"http:\/\/cfile27.uf.tistory.com\/image\/261CC43B543DF3EA2ED4D5","width":350,"height":200},"classes":[]},{"id":1284,"url":"https:\/\/blog.box.kr\/?p=1284","url_meta":{"origin":619,"position":4},"title":"MySql \uad00\ub9ac","date":"2021-12-30","format":false,"excerpt":"Table\uc5d0 \uc0dd\uc131\ub418\uc5b4 \uc788\ub294 Indexes \uc758 \uc6a9\ub7c9 \ud655\uc778 select database_name, table_name, index_name, round((stat_value*@@innodb_page_size)\/1024\/1024, 2) SizeMB, round(((100\/(SELECT INDEX_LENGTH FROM INFORMATION_SCHEMA.TABLES t WHERE t.TABLE_NAME = iis.table_name and t.TABLE_SCHEMA = iis.database_name))*(stat_value*@@innodb_page_size)), 2) `Percentage` from mysql.innodb_index_stats iis where stat_name='size' and table_name = 'TargetTable' and database_name = 'targetDB' show table status from database_name; -- databases\uc5d0 \uc788\ub294\u2026","rel":"","context":"In &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":74,"url":"https:\/\/blog.box.kr\/?p=74","url_meta":{"origin":619,"position":5},"title":"Logging\uc124\uc815 for JEUS5","date":"2014-06-12","format":false,"excerpt":"Logging\uc124\uc815 for JEUS5 \uc18c\uac1c \uc774 \ubb38\uc11c\ub294 JEUS 5\uc758 \uc6f9 \uad00\ub9ac\uc790\ub97c \uc0ac\uc6a9\ud55c logging \uc124\uc815 \ubc29\ubc95 \ubc0f customization \ubc29\ubc95, log4j \uc0ac\uc6a9\ubc95 \ub4f1\uc744 \uc124\uba85\ud55c\ub2e4. \uae30\ubcf8logger \ud30c\uc77c \ucd5c\ucd08 JEUS \uc124\uce58 \uc2dc, JEUS log\ub294 default\ub85c console handler\ub97c \uc0ac\uc6a9\ud558\uae30 \ub54c\ubb38\uc5d0 JEUS manager\uc640 \ubaa8\ub4e0 engine container\uc758 log message\uac00 stdout\ud615\ud0dc\ub85c \ucd9c\ub825\ub41c\ub2e4. \ub610\ud55c web container \uc758 access log\uac00 $JEUS_HOME\/logs\/<\ub178\ub4dc\uba85>\/<\ub178\ub4dc\uba85>_<\ucee8\ud14c\uc774\ub108\uba85>\/servlet\/accesslog\/access.log\u2026","rel":"","context":"In &quot;JEUS &amp; WEBToB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/619"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=619"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/619\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}