{"id":2516,"date":"2018-01-29T12:52:20","date_gmt":"2018-01-29T03:52:20","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2516"},"modified":"2023-04-14T14:33:30","modified_gmt":"2023-04-14T05:33:30","slug":"%ec%ba%90%eb%a6%ad%ed%84%b0%ec%85%8b%ec%9d%b4-%eb%8b%a4%eb%a5%b8-db%ec%9d%98-%ed%95%9c%ea%b8%80-%ea%b9%a8%ec%a7%90-%ed%98%84%ec%83%81-%ed%95%b4%ea%b2%b0-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2516","title":{"rendered":"\uce90\ub9ad\ud130\uc14b\uc774 \ub2e4\ub978 DB\uc758 \ud55c\uae00 \uae68\uc9d0 \ud604\uc0c1 \ud574\uacb0 \ubc29\ubc95"},"content":{"rendered":"

\uce90\ub9ad\ud130\uc14b\uc774 \ub2e4\ub978 DB\uc758 \ud55c\uae00 \uae68\uc9d0 \ud604\uc0c1 \ud574\uacb0 \ubc29\ubc95
\n<\/span><\/p>\n

SAP \uc758 \uacbd\uc6b0 \uace0\uc815\uc801\uc73c\ub85c WE8DEC \uc720\ub7fd\ud615 \uc5b8\uc5b4\ub97c \uc4f0\uac8c \ub418\ubbc0\ub85c \ub370\uc774\ud130\ub97c DB Layer\uc5d0\uc11c \uaebc\ub0bc \uacbd\uc6b0<\/p>\n

\uae68\uc9d0 \ud604\uc0c1\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774\ub97c \ud574\uacb0 \ud558\ub294 \ubc29\ubc95 \uc785\ub2c8\ub2e4.<\/p>\n

\ub17c\ub9ac\uc801 \uadf8\ub9bc \uc785\ub2c8\ub2e4.<\/p>\n

\"\"
\n<\/span><\/p>\n

\uc791\uc5c5 \ub300\uc0c1 \ud14c\uc774\ube14
\n<\/span><\/p>\n

\ub300\uc0c1 \ud14c\uc774\ube14<\/p>\n

ZSMS03 \uad6c\uc870<\/p>\n

CMP_MSG_ID NOT NULL VARCHAR2(20)<\/p>\n

ZMDID NOT NULL VARCHAR2(10)<\/p>\n

CMP_USR_ID NOT NULL VARCHAR2(5)<\/p>\n

ODR_FG NOT NULL VARCHAR2(1)<\/p>\n

MSG_GB NOT NULL VARCHAR2(1)<\/p>\n

WRT_DTTM NOT NULL VARCHAR2(14)<\/p>\n

SND_DTTM NOT NULL VARCHAR2(14)<\/p>\n

SMS_GB NOT NULL VARCHAR2(1)<\/p>\n

USED_CD NOT NULL VARCHAR2(3)<\/p>\n

RCV_PHN_ID NOT NULL VARCHAR2(15)<\/p>\n

CALLBACK NOT NULL VARCHAR2(15)<\/p>\n

SND_MSG RAW(2000) \u00df<\/span> \ud55c\uae00 \uceec\ub7fc
\n<\/strong><\/span><\/p>\n

REG_SND_DTTM NOT NULL VARCHAR2(14)<\/p>\n

SND_PHN_ID NOT NULL VARCHAR2(15)<\/p>\n

REG_RCV_DTTM NOT NULL VARCHAR2(14)<\/p>\n

EXPIRE_VAL NOT NULL VARCHAR2(7)<\/p>\n

SMS_ST NOT NULL VARCHAR2(1)<\/p>\n

RSLT_VAL NOT NULL VARCHAR2(4)<\/p>\n

CMP_SND_DTTM NOT NULL VARCHAR2(14)<\/p>\n

CMP_RCV_DTTM NOT NULL VARCHAR2(14)<\/p>\n

RCV_MNO_CD NOT NULL VARCHAR2(5)<\/p>\n

RSRVD_ID NOT NULL VARCHAR2(20)<\/p>\n

RSRVD_WD NOT NULL VARCHAR2(32)<\/p>\n

ASSIGN_CD NOT NULL VARCHAR2(1)<\/p>\n

SND_GB NOT NULL VARCHAR2(1)<\/p>\n

SND_SKT_FG NOT NULL VARCHAR2(1)<\/p>\n

SND_KTF_FG NOT NULL VARCHAR2(1)<\/p>\n

SND_LGT_FG NOT NULL VARCHAR2(1)<\/p>\n

NAT_CD NOT NULL VARCHAR2(3)<\/p>\n

MSG_ID NOT NULL VARCHAR2(20)<\/p>\n

ZRDATE NOT NULL VARCHAR2(8)<\/p>\n

ZRTIME NOT NULL VARCHAR2(6)<\/p>\n

ZFLAG NOT NULL VARCHAR2(1)<\/p>\n

\uc791\uc5c5 \uc808\ucc28
\n<\/strong><\/span><\/p>\n

1. \ubdf0 \uc0dd\uc131
\n<\/strong><\/p>\n

< SAP R\/3 DB : \uce90\ub9ad\ud130\uc14b WE8DEC >
\n<\/strong><\/p>\n

CREATE VIEW forsms.ZSMS03 AS<\/p>\n

SELECT CMP_MSG_ID,<\/p>\n

ZMDID,<\/p>\n

CMP_USR_ID,<\/p>\n

ODR_FG,<\/p>\n

MSG_GB,<\/p>\n

WRT_DTTM,<\/p>\n

SND_DTTM,<\/p>\n

SMS_GB,<\/p>\n

USED_CD,<\/p>\n

RCV_PHN_ID,<\/p>\n

CALLBACK,<\/p>\n

UTL_RAW.CAST_TO_RAW(SND_MSG) SND_MSG,\u00a0 \u00a0<\/span>\u00df<\/span> \ubdf0\ub97c \uc0dd\uc131 \ud558\uba74\uc11c RAW \uac12\uc744 BYTE \uac12\uc73c\ub85c \ubcc0\ud658<\/strong><\/span><\/p>\n

REG_SND_DTTM,<\/p>\n

SND_PHN_ID,<\/p>\n

REG_RCV_DTTM,<\/p>\n

EXPIRE_VAL,<\/p>\n

SMS_ST,<\/p>\n

RSLT_VAL,<\/p>\n

CMP_SND_DTTM,<\/p>\n

CMP_RCV_DTTM,<\/p>\n

RCV_MNO_CD,<\/p>\n

RSRVD_ID,<\/p>\n

RSRVD_WD,<\/p>\n

ASSIGN_CD,<\/p>\n

SND_GB,<\/p>\n

SND_SKT_FG,<\/p>\n

SND_KTF_FG,<\/p>\n

SND_LGT_FG,<\/p>\n

NAT_CD,<\/p>\n

MSG_ID,<\/p>\n

ZRDATE,<\/p>\n

ZRTIME,<\/p>\n

ZFLAG<\/p>\n

FROM SAPR3.ZSMS03;<\/p>\n

< \uc218\uc2e0 DB I-service DB : KC15KSO5601 >
\n<\/strong><\/p>\n

1. DB \ub9c1\ud06c\ub97c \uc774\uc6a9\ud55c \uc6d0\uaca9\uc9c0\uc5d0\uc11c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \ub9c1\ud06c \uc0dd\uc131
\n<\/strong><\/p>\n

> create public database link ads_sms_link connect to forsms identified by forsms1234 using ‘ADS’ ;<\/p>\n

2. BYTE\ub97c varchar2 \uac12\uc73c\ub85c \ubcc0\ud658 \ud568\uc218\ub97c \uc774\uc6a9\ud558\uc5ec \ubdf0 \uc0dd\uc131
\n<\/strong><\/p>\n

CREATE VIEW arreo_sms.ZSMS03 AS<\/p>\n

SELECT CMP_MSG_ID,<\/p>\n

ZMDID,<\/p>\n

CMP_USR_ID,<\/p>\n

ODR_FG,<\/p>\n

MSG_GB,<\/p>\n

WRT_DTTM,<\/p>\n

SND_DTTM,<\/p>\n

SMS_GB,<\/p>\n

USED_CD,<\/p>\n

RCV_PHN_ID,<\/p>\n

CALLBACK,<\/p>\n

UTL_RAW.CAST_TO_VARCHAR2(SND_MSG) SND_MSG,\u00a0 \u00a0\u00a0<\/span>\u00df<\/span> \ub2e4\uc2dc VARCHAR2 \uac12\uc73c\ub85c \ubcc0\uacbd
\n<\/strong><\/span><\/p>\n

REG_SND_DTTM,<\/p>\n

SND_PHN_ID,<\/p>\n

REG_RCV_DTTM,<\/p>\n

EXPIRE_VAL,<\/p>\n

SMS_ST,<\/p>\n

RSLT_VAL,<\/p>\n

CMP_SND_DTTM,<\/p>\n

CMP_RCV_DTTM,<\/p>\n

RCV_MNO_CD,<\/p>\n

RSRVD_ID,<\/p>\n

RSRVD_WD,<\/p>\n

ASSIGN_CD,<\/p>\n

SND_GB,<\/p>\n

SND_SKT_FG,<\/p>\n

SND_KTF_FG,<\/p>\n

SND_LGT_FG,<\/p>\n

NAT_CD,<\/p>\n

MSG_ID,<\/p>\n

ZRDATE,<\/p>\n

ZRTIME,<\/p>\n

ZFLAG<\/p>\n

FROM ZSMS03@ads_sms_link;<\/p>\n

\uc791\uc5c5 \uacb0\uacfc
\n<\/strong><\/span><\/p>\n

< \ubdf0 \ub97c \uc774\uc6a9\ud55c \uc870\ud68c \uacb0\uacfc > <\/span>
\n<\/strong><\/p>\n

select * from arreo_sms.ZSMS03 ;<\/p>\n

\u2026<\/p>\n

00000000000000000001\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LOGIC\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VKIS1 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 01000005846<\/p>\n

SMS \ubb38\uc790 \uc804\uc1a1 \ud14c\uc2a4\ud2b8 \uc785\ub2c8\ub2e4. \u00df<\/span> \ud55c\uae00\uc744 \ubc14\ub85c \ubcf4\uc5ec\uc9d0<\/strong><\/span><\/p>\n

01000005846\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0000000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0000<\/p>\n

20100906\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 140000<\/p>\n

< \uae30\uc874 \ud14c\uc774\ube14\uc744 \ubc14\ub85c \uc870\ud68c\ud55c \uacb0\uacfc >
\n<\/strong><\/span><\/p>\n

select * from sapr3.ZSMS03@ads_sms_link;<\/p>\n

700 00000000000000000001\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0LOGIC\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VKIS1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 01000005846<\/p>\n

SMS \u00b9?AU Au\u00bcU A\u0152\u00bd\u00ba\u00c6? AO?I?U. \u00df<\/span> \ud55c\uae00 \uae68\uc9d0<\/strong><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 01000005846<\/p>\n

0000000 \u00a0\u00a0\u00a0\u00a0 0000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20100906\u00a0\u00a0\u00a0\u00a0 140000<\/p>\n","protected":false},"excerpt":{"rendered":"

\uce90\ub9ad\ud130\uc14b\uc774 \ub2e4\ub978 DB\uc758 \ud55c\uae00 \uae68\uc9d0 \ud604\uc0c1 \ud574\uacb0 \ubc29\ubc95 SAP \uc758 \uacbd\uc6b0 \uace0\uc815\uc801\uc73c\ub85c WE8DEC \uc720\ub7fd\ud615 \uc5b8\uc5b4\ub97c \uc4f0\uac8c \ub418\ubbc0\ub85c \ub370\uc774\ud130\ub97c DB Layer\uc5d0\uc11c \uaebc\ub0bc \uacbd\uc6b0 \uae68\uc9d0 \ud604\uc0c1\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud574\uacb0 \ud558\ub294 \ubc29\ubc95 \uc785\ub2c8\ub2e4. \ub17c\ub9ac\uc801 \uadf8\ub9bc \uc785\ub2c8\ub2e4. \uc791\uc5c5 \ub300\uc0c1 \ud14c\uc774\ube14 \ub300\uc0c1 \ud14c\uc774\ube14 ZSMS03 \uad6c\uc870 CMP_MSG_ID NOT NULL VARCHAR2(20) ZMDID NOT NULL VARCHAR2(10) CMP_USR_ID NOT NULL VARCHAR2(5) ODR_FG NOT NULL […]<\/p>\n","protected":false},"author":1,"featured_media":2502,"comment_status":"closed","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":[219],"tags":[844,843],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/Fotolia_51644947_XS.jpg?fit=414%2C290","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2516"}],"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=2516"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2516\/revisions"}],"predecessor-version":[{"id":4811,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2516\/revisions\/4811"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2502"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2516"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}