Página Principal Explorar Ajuda
Iniciar Sessão
yusuf
/
btnmw-server-local
biforcado de wisnu/btnmw-server-local
1
0
Fork 0
Ficheiros
Árvore: 72bc8f420c
Ramos Etiquetas
btnmw-server-lo...
/
mwconfig
/
cicd
/
01-script.sql

01-script.sql 9.7 KB
Histórico Em bruto

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148 
  1. -- # 2023-09-2611:48
    2. 

  2. CALL MWCONFIG.MERGE_MAPPING('req-core.itm.0200.251010.001001001',NULL,'[itm][itsii]');
    3. 

  3. CALL MWCONFIG.MERGE_MAPPING('req-core.itm.0200.251020.001001001',NULL,'[itm][itsii]');
    4. 

  4. CALL MWCONFIG.MERGE_MAPPING('req-core.itm.0200.252010.001001001',NULL,'[itm][itsii]');
    5. 

  5. CALL MWCONFIG.MERGE_MAPPING('req-core.itm.0200.252020.001001001',NULL,'[itm][itsii]');
    6. 

  6. 

  7. CALL MWCONFIG.MERGE_MAPPING_GROUP('req-core.itm.0200.251010.001001001',1,'/data/body','/data/body','req-core.itm',1);
    8. 

  8. CALL MWCONFIG.MERGE_MAPPING_GROUP('req-core.itm.0200.251020.001001001',1,'/data/body','/data/body','req-core.itm.0200.251010.001001001',1);
    9. 

  9. CALL MWCONFIG.MERGE_MAPPING_GROUP('req-core.itm.0200.252010.001001001',1,'/data/body','/data/body','req-core.itm.0200.251010.001001001',1);
    10. 

  10. CALL MWCONFIG.MERGE_MAPPING_GROUP('req-core.itm.0200.252020.001001001',1,'/data/body','/data/body','req-core.itm.0200.251010.001001001',1);
    11. 

  11. 

  12. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'!code','AXISSYSTEMSDNBHD.0000005011', NULL);
    13. 

  13. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'dspTransactionCode','5011', NULL);
    14. 

  14. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'TLBF01','${msg.fromAccount}', NULL);
    15. 

  15. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'TLBF02','${msg.amountTransaction."!number"}', NULL);
    16. 

  16. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'TLBF15','${msg.toAccount}', NULL);
    17. 

  17. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'TLBTCD','5011', NULL);
    18. 

  18. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'TLBTPN','KE ${msg.additionalDataPrivate?."!value".padRight(15," ").substring(0,15).trim()} BTN ${msg.toAccount?."!value"!=null?msg.toAccount."!value".padLeft(19,"0").substring(3,19):""}', NULL);
    19. 

  19. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'TLBDS1','${msg.fromAccount?."!value"!=null?msg.fromAccount."!value".padLeft(19,"0").substring(3,19):""} ke ${msg.toAccount?."!value"!=null?msg.toAccount."!value".padLeft(19,"0").substring(3,19):""}', NULL);
    20. 

  20. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'TLBDS2','${msg.track2Data."!value".padRight(16,"0").substring(0,16)} ATM ${msg.cardAcceptorTerminalIdentification}', NULL);
    21. 

  21. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'TLXUFD','TRFATM', NULL);
    22. 

  22. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'RMPYNM','DR ${msg.additionalDataPrivate?."!value".padRight(61," ").substring(46,61).trim()} BTN ${msg.fromAccount?."!value"!=null?msg.fromAccount."!value".padLeft(19,"0").substring(3,19):""}', NULL);
    23. 

  23. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'RMNAME','DR ${msg.additionalDataPrivate?."!value".padRight(61," ").substring(46,61).trim()} ${msg.fromAccount?."!value"!=null?msg.fromAccount."!value".padLeft(19,"0").substring(3,19):""}', NULL);
    24. 

  24. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251010.001001001',1,'RMADD2','KE ${msg.additionalDataPrivate?."!value".padRight(15," ").substring(0,15).trim()} ${msg.toAccount?."!value"!=null?msg.toAccount."!value".padLeft(19,"0").substring(3,19):""}', NULL);
    25. 

  25. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251020.001001001',1,'!code','AXISSYSTEMSDNBHD.0000005012', NULL);
    26. 

  26. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251020.001001001',1,'dspTransactionCode','5012', NULL);
    27. 

  27. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.251020.001001001',1,'TLBTCD','5012', NULL);
    28. 

  28. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.252010.001001001',1,'!code','AXISSYSTEMSDNBHD.0000005013', NULL);
    29. 

  29. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.252010.001001001',1,'dspTransactionCode','5013', NULL);
    30. 

  30. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.252010.001001001',1,'TLBTCD','5013', NULL);
    31. 

  31. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.252020.001001001',1,'!code','AXISSYSTEMSDNBHD.0000005014', NULL);
    32. 

  32. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.252020.001001001',1,'dspTransactionCode','5014', NULL);
    33. 

  33. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.itm.0200.252020.001001001',1,'TLBTCD','5014', NULL);
    34. 

  34. 

  35. 

  36. 

  37. CALL MWCONFIG.MERGE_MAPPING('res-core.itm.0200.251010.001001001', NULL,'[itm][itsii]');
    38. 

  38. CALL MWCONFIG.MERGE_MAPPING('res-core.itm.0200.251020.001001001', NULL,'[itm][itsii]');
    39. 

  39. CALL MWCONFIG.MERGE_MAPPING('res-core.itm.0200.252010.001001001', NULL,'[itm][itsii]');
    40. 

  40. CALL MWCONFIG.MERGE_MAPPING('res-core.itm.0200.252020.001001001', NULL,'[itm][itsii]');
    41. 

  41. 

  42. CALL MWCONFIG.MERGE_MAPPING_GROUP('res-core.itm.0200.251010.001001001',1,'/data/body','/data/body','res-core.itm.0200',1);
    43. 

  43. CALL MWCONFIG.MERGE_MAPPING_GROUP('res-core.itm.0200.251020.001001001',1,'/data/body','/data/body','res-core.itm.0200.251010.001001001',1);
    44. 

  44. CALL MWCONFIG.MERGE_MAPPING_GROUP('res-core.itm.0200.252010.001001001',1,'/data/body','/data/body','res-core.itm.0200.251010.001001001',1);
    45. 

  45. CALL MWCONFIG.MERGE_MAPPING_GROUP('res-core.itm.0200.252020.001001001',1,'/data/body','/data/body','res-core.itm.0200.251010.001001001',1);
    46. 

  46. 

  47. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('res-core.itm.0200.251010.001001001',1,'additionalDataPrivate','${head.request.data.body.original.additionalDataPrivate}', NULL);
    48. 

  48. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('res-core.itm.0200.251010.001001001',1,'additionalResponseData','${decimalFormat("0", (msg.AMT2_F1."!number"*100)).length()>12?"999999999999":decimalFormat("0", (msg.AMT2_F1."!number"*100)).padLeft(12, "0")}${decimalFormat("0", (msg.AMT1_F1."!number"*100)).length()>12?"999999999999":decimalFormat("0", (msg.AMT1_F1."!number"*100)).padLeft(12, "0")}', NULL);
    49. 

  49. 

  50. 

  51. ---------- #TEST UPSERT SECTION
    52. 

  52. 

  53. -- #TEST UPSERT SECTION
    54. 

  54. 

  55. -- ADAPTOR
    56. 

  56. -- CALL MWCONFIG.MERGE_ADAPTOR(ID, DESCRIPTION, ASYNCHRONOUS)
    57. 

  57. CALL MWCONFIG.MERGE_ADAPTOR('core-sms', NULL, 0);
    58. 

  58. 

  59. -- CODEX
    60. 

  60. -- CALL MWCONFIG.MERGE_CODEX(ID, ALLOW_PARTIAL, XML)
    61. 

  61. CALL MWCONFIG.MERGE_CODEX('iso-8583-sms', NULL, NULL);
    62. 

  62. 

  63. -- ADAPTOR CODEX
    64. 

  64. -- CALL MWCONFIG.MERGE_ADAPTOR_CODEX(ADAPTOR_ID, ID, CODEX_ID)
    65. 

  65. CALL MWCONFIG.MERGE_ADAPTOR_CODEX('core-sms','incoming','iso-8583-sms');
    66. 

  66. 

  67. -- ADAPTOR PARAM
    68. 

  68. -- CALL MWCONFIG.MERGE_ADAPTOR_PARAM(ADAPTOR_ID, NAME, VALUE)
    69. 

  69. CALL MWCONFIG.MERGE_ADAPTOR_PARAM('core-sms','maxConnection','1');
    70. 

  70. 

  71. -- CHARGES
    72. 

  72. -- CALL MWCONFIG.MERGE_CHARGES(ID, C1_VALUE, C1_NAME, C1_SCRIPT, C1_ACCOUNT, C2_VALUE, C2_NAME, C2_SCRIPT, C2_ACCOUNT, C3_VALUE, C3_NAME, C3_SCRIPT, C3_ACCOUNT, C4_VALUE, C4_NAME, C4_SCRIPT, C4_ACCOUNT, C5_VALUE, C5_NAME, C5_SCRIPT, C5_ACCOUNT)
    73. 

  73. CALL MWCONFIG.MERGE_CHARGES('edc-amp-link-inquiry-LMP', 3500,'fee nasabah', NULL, NULL, 0,'fee switcher', NULL, NULL, 0,'fee acquirer', NULL, NULL, 0,'fee promosi', NULL, NULL, 0,'fee issuer', NULL, NULL);
    74. 

  74. 

  75. -- CLIENT
    76. 

  76. -- CALL MWCONFIG.MERGE_CLIENT_TARGET(CLIENT_ID, ID, HOST, WEIGHT, SEQ)
    77. 

  77. CALL MWCONFIG.MERGE_CLIENT('core-sms', 30000, NULL, NULL, NULL, 0, NULL,'core-client');
    78. 

  78. 

  79. -- CLIENT TARGET
    80. 

  80. -- CALL MWCONFIG.MERGE_CLIENT_TARGET(CLIENT_ID, ID, HOST, WEIGHT, SEQ)
    81. 

  81. CALL MWCONFIG.MERGE_CLIENT_TARGET('core-sms','core-sms','dumbroker-dummy:13001', NULL,1);
    82. 

  82. 

  83. -- CONFIG_METADATA
    84. 

  84. 

  85. -- DBCONN
    86. 

  86. -- CALL MWCONFIG.MERGE_DBCONN(ID,DRIVER,URL,USERNAME,PASSWORD,SCHEMA,TIMEOUT)
    87. 

  87. CALL MWCONFIG.MERGE_DBCONN('core-sms','com.ibm.db2.jcc.DB2Driver','jdbc:db2://wmbserver:50000/temp','usr_mdw','twcFKd9CNDCs8Sos21P+ltQFiIvtmOMGL79NQnexL0c=','temp', NULL);
    88. 

  88. 

  89. 

  90. -- DEV_TELLER_MAP
    91. 

  91. -- CALL MWCONFIG.MERGE_DEV_TELLER_MAP(DEV_ID, GROUP, DEVICE_ID, DEVICE_NAME, TERMINAL_ID, TERMINAL_IP, TELLER_ID, CTRL_UNIT_ID)
    92. 

  92. CALL MWCONFIG.MERGE_DEV_TELLER_MAP('edc','00001003','00001003','00001003','10.14.1.107','7200014','C15');
    93. 

  93. 

  94. -- DTREE
    95. 

  95. -- CALL MWCONFIG.MERGE_DTREE(GROUP, PATH, VALUE, MODULE)
    96. 

  96. CALL MWCONFIG.MERGE_DTREE('SMS-CODE','0200','0200.${msg.processingCode?.padLeft(6, "0")}','[sms]');
    97. 

  97. 

  98. -- DTREE_MAP
    99. 

  99. 

  100. -- ERROR_MAP
    101. 

  101. -- CALL MWCONFIG.MERGE_ERROR_MAP(GROUP, ORIGINAL, TARGET, DETAIL)
    102. 

  102. CALL MWCONFIG.MERGE_ERROR_MAP('core-sms','00','00', NULL);
    103. 

  103. 

  104. -- HOST
    105. 

  105. -- CALL MWCONFIG.MERGE_HOST(ID, HOST, USERNAME, PASSWORD, CONTEXT)
    106. 

  106. CALL MWCONFIG.MERGE_HOST('core-sms','127.0.0.1','temp','temp','temp');
    107. 

  107. 

  108. -- MAPPING
    109. 

  109. -- CALL MWCONFIG.MERGE_MAPPING(ID, DESCRIPTION, MODULE)
    110. 

  110. CALL MWCONFIG.MERGE_MAPPING('req-core.sms', NULL,'[sms]');
    111. 

  111. 

  112. -- MAPPING GROUP
    113. 

  113. -- CALL MWCONFIG.MERGE_MAPPING_GROUP(MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
    114. 

  114. CALL MWCONFIG.MERGE_MAPPING_GROUP('req-core.sms',1,'/data/body','/data/body',NULL, NULL);
    115. 

  115. 

  116. -- MAPPING GROUP LINE
    117. 

  117. -- CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
    118. 

  118. CALL MWCONFIG.MERGE_MAPPING_GROUP_LINE('req-core.sms',1,'messageType','0200', NULL);
    119. 

  119. 

  120. -- PARAM MAP
    121. 

  121. -- CALL MWCONFIG.MERGE_PARAM_MAP(GROUP, NAME, VALUE, SEQ, DESCRIPTION)
    122. 

  122. CALL MWCONFIG.MERGE_PARAM_MAP('coa','gl-tagihan-edc-amp','187150491428', NULL, NULL);
    123. 

  123. 

  124. -- PARSER
    125. 

  125. -- CALL MWCONFIG.MERGE_PARSER(ID)
    126. 

  126. CALL MWCONFIG.MERGE_PARSER('core-sms');
    127. 

  127. 

  128. -- PARSER CODEX
    129. 

  129. -- CALL MWCONFIG.MERGE_PARSER_CODEX(PARSER_ID, ID, CODEX_ID)
    130. 

  130. -- #CALL MWCONFIG.MERGE_PARSER_CODEX('core-sms','iso-8583-itm','iso-8583-itm');
    131. 

  131. 

  132. -- ROUTING TABLE
    133. 

  133. -- CALL MWCONFIG.MERGE_ROUTING_TABLE(ID, CODE_START, CODE_END, CHANNEL, START_DATE, END_DATE, QUEUE, STATUS, SUBCODEX, ADDITIONAL, REPLY_TO, REPLY_TO_QMGR)
    134. 

  134. CALL MWCONFIG.MERGE_ROUTING_TABLE('*','*','sms', CURRENT TIMESTAMP , NULL,'SMS_IN','ACTIVE', NULL, NULL, NULL, NULL);
    135. 

  135. 

  136. -- RPG CALL
    137. 

  137. -- CALL MWCONFIG.MERGE_RPG_CALL(ID, CMD, HOST, TIMEOUT)
    138. 

  138. -- #CALL MWCONFIG.MERGE_RPG_CALL('core-sms','temp','temp', 60000);
    139. 

  139. 

  140. -- RPG CALL ARG
    141. 

  141. -- CALL MWCONFIG.MERGE_RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, TYPE, LENGTH)
    142. 

  142. -- #CALL MWCONFIG.MERGE_RPG_CALL_ARG('core-sms',1,'temp','temp',15);
    143. 

  143. 

  144. 

  145. -- SERVER_PORT
    146. 

  146. -- CALL MWCONFIG.MERGE_SERVER_PORT(ADAPTOR_ID, PORT, SERVER, GROUP)
    147. 

  147. CALL MWCONFIG.MERGE_SERVER_PORT('core-sms',10101,'server-1','core-sms');
    148. 

  148.