{"id":2894,"date":"2018-02-03T20:27:19","date_gmt":"2018-02-03T11:27:19","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2894"},"modified":"2018-02-03T20:27:19","modified_gmt":"2018-02-03T11:27:19","slug":"sql%eb%a1%9c%eb%8d%94ibm-mainframe-%ec%97%90%ec%84%9c-%eb%b0%9c%ec%83%9d%eb%90%9c-data%ed%95%9c%ea%b8%80%ed%8f%ac%ed%95%a8%eb%a5%bc-unix%eb%a1%9c-load%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2894","title":{"rendered":"[SQL\ub85c\ub354]IBM MAINFRAME \uc5d0\uc11c \ubc1c\uc0dd\ub41c DATA(\ud55c\uae00\ud3ec\ud568)\ub97c UNIX\ub85c LOAD\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"<div id=\"page\" class=\"hfeed site\">\n<div id=\"main\" class=\"clearfix\">\n<div class=\"inner-wrap clearfix\">\n<div class=\"main-content-section clearfix\">\n<div id=\"primary\">\n<div id=\"content\" class=\"clearfix\">\n<div class=\"article-container\">\n<div class=\"article-content clearfix\">\n<div class=\"entry-content clearfix\">\n<div>\n<div id=\"4a775fde-a54f-459a-a91e-961ff1bc2e5a\" class=\"postBody\" contenteditable=\"true\">\n<p>\u00a0\u00a0IBM mainframe \uad70\u00a0(OS\/390,MVS,VM,OS\/400)\uc5d0\uc11c \uc0dd\uc0b0\ub41c\u00a0fixed length data\ub97c\u00a0\u00a0UNIX\uc0c1\uc73c\ub85c\u00a0load\uc2dc\uc5d0\ub294 \uc0ac\uc6a9\ud558\ub294\u00a0code\uc758 \ucc28\uc774\ub85c \uc778\ud55c \ud55c\uae00\ubb38\uc81c\uac00 \ubc1c\uc0dd \ud560\uc218 \uc788\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&#8211; EBCDIC(extended binary coded decimal interchange code)\uacfc\u00a0 ASCII(The american standard code for information interchange)\uac04\uc758\u00a0\u00a0double byte character code \uccb4\uacc4\uc758 \ucc28\uc774\ub85c \uc778\ud55c \ubb38\uc81c \ubc1c\uc0dd<\/p>\n<p>&nbsp;<\/p>\n<p>. EBCDIC\uc740\u00a08 bit \uccb4\uacc4\uc758\u00a0code\ub85c\u00a0double byte character\uc758 \ud45c\ud604\uc740\u00a0 SO(hex 0E, shift out), SI(hex 0F, shift in)\ub97c \uc774\uc6a9\ud558\uc5ec \ud45c\ud604<\/p>\n<p>. ASCII\ub294\u00a07 bit \uccb4\uacc4\uc758\u00a0code\ub85c\u00a00 bit\uc758\u00a0on\/off\ub85c \ud45c\ud604\ud55c\ub2e4. 0 bit\uac00\u00a0on \uc774 \ub418\uc5b4 \uc788\uc73c\uba74\u00a0code page\ubc0f\u00a0code\uac12\uc73c\ub85c\u00a0double byte chracter\ub97c \ud45c\ud604 \uadf8\ub7ec\ubbc0\ub85c\u00a0ftp\ub97c \uc774\uc6a9\ud558\uc5ec\u00a0code convertion\uc2dc\uc5d0\ub294\u00a0SO\/SI\uac00\u00a0null\ub85c \ubcc0\ud658\ub418\uc5b4\u00a0 data\uc758 \uae38\uc774\uac00 \ub2ec\ub77c\uc9c4\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&#8211; TCP\/IP ftp utility\uc911 \ud55c\uae00\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd(KNET\/TCP)<\/p>\n<p>\uc704\uc640 \uac19\uc740 \uc774\uc720\ub85c\u00a0EBCDIC \uccb4\uacc4\uc758\u00a0DATA\ub97c\u00a0ASCII\uccb4\uacc4\uc758 \uc2dc\uc2a4\ud15c\uc5d0\u00a0LOAD\uc2dc\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \ud558\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\ubc29\ubc95)<\/p>\n<p>1) IBM MAINFRAME\uc758\u00a0RECORD LENGTH\ub97c \ud655\uc778\ud55c\ub2e4.<\/p>\n<p>2) BINARY MODE\ub85c\u00a0FTP \ud55c\ub2e4.<\/p>\n<p>3) SQLLOADER\ub97c \uc544\ub798\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c\u00a0LOAD\ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:plsql decode:true \">\u00a0\u00a0sqlldr userid=xxx\/xxx control=kr.ctl data=.\/xxxx.dat direct=true\r\n\r\n\r\n\r\n\u00a0\u00a0--- kr.ctl\r\n\r\n\u00a0\u00a0unrecoverable\r\n\r\n\u00a0\u00a0load data\r\n\r\n\u00a0\u00a0characterset KO16DBCS\r\n\r\n\u00a0\u00a0infile '\/data2\/d4\/kid01' \"FIX 550\"\r\n\r\n\u00a0\u00a0append\r\n\r\n\u00a0\u00a0into table krtbl\r\n\r\n\u00a0\u00a0\u00a0\u00a0( col1 position(1:10) \u00a0char(10))<\/pre>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0\u00a0IBM mainframe \uad70\u00a0(OS\/390,MVS,VM,OS\/400)\uc5d0\uc11c \uc0dd\uc0b0\ub41c\u00a0fixed length data\ub97c\u00a0\u00a0UNIX\uc0c1\uc73c\ub85c\u00a0load\uc2dc\uc5d0\ub294 \uc0ac\uc6a9\ud558\ub294\u00a0code\uc758 \ucc28\uc774\ub85c \uc778\ud55c \ud55c\uae00\ubb38\uc81c\uac00 \ubc1c\uc0dd \ud560\uc218 \uc788\ub2e4. &nbsp; &#8211; EBCDIC(extended binary coded decimal interchange code)\uacfc\u00a0 ASCII(The american standard code for information interchange)\uac04\uc758\u00a0\u00a0double byte character code \uccb4\uacc4\uc758 \ucc28\uc774\ub85c \uc778\ud55c \ubb38\uc81c \ubc1c\uc0dd &nbsp; . EBCDIC\uc740\u00a08 bit \uccb4\uacc4\uc758\u00a0code\ub85c\u00a0double byte character\uc758 \ud45c\ud604\uc740\u00a0 SO(hex 0E, shift out), SI(hex 0F, shift in)\ub97c \uc774\uc6a9\ud558\uc5ec \ud45c\ud604 . [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2876,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[10],"tags":[651,956,95],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Cover1.png?fit=1000%2C730","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2894"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2894"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2894\/revisions"}],"predecessor-version":[{"id":2895,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2894\/revisions\/2895"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2876"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2894"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}