Inicio Explorar Axuda
Iniciar sesión
fiqri
/
btn-mdw-ace-server-local
1
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: 29a7959698
Ramas Etiquetas
btn-mdw-ace-ser...
/
mwconfig
/
migration
/
MWCONFIG_INITDB_DUMMY_IST_CONN.sql

MWCONFIG_INITDB_DUMMY_IST_CONN.sql 19 KB
Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 
  1. INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, TIMESTAMP)
    2. 

  2. 	VALUES ('dic-30801', 'Dummy IST Conn', 1, CURRENT USER, CURRENT TIMESTAMP);
    3. 

  3. 

  4. INSERT INTO MWCONFIG.CODEX (ID, ALLOW_PARTIAL, XML, MODIFIED_BY, TIMESTAMP)
    5. 

  5. 	VALUES ('iso-8583-cws', NULL, '<codex id="iso-8583-cws" escape="true">
    6. 

  6. 	<field id="packetLength" type="groupLength" length="4"/>
    7. 

  7. 	<field id="messageType" type="string" length="4" padding-mode="right" padding-char=" " />
    8. 

  8. 	<field id="bitmap" type="bitmap">
    9. 

  9. 		<field id="primaryAccountNumber" bit="2" type="string" length="19" format="llvar" />
    10. 

  10. 		<field id="processingCode" bit="3" type="string" length="6" />
    11. 

  11. 		<field id="amountTransaction" bit="4" type="string" length="12" padding-mode="left" padding-char="0" />
    12. 

  12. 		<field id="amountSettlement" bit="5" type="string" length="12" padding-mode="left" padding-char="0" />
    13. 

  13. 		<field id="amountCardholderBilling" bit="6" type="string" length="12" padding-mode="left" padding-char="0" />
    14. 

  14. 		<field id="transmissionDateTime" bit="7" type="string" length="10" />
    15. 

  15. 		<field id="amountCardholderBillingFee" bit="8" type="string" length="8" padding-mode="left" padding-char="0" />
    16. 

  16. 		<field id="conversionRateSettlement" bit="9" type="string" length="8" padding-mode="left" padding-char="0" />
    17. 

  17. 		<field id="conversionRateCardholderBilling" bit="10" type="string" length="8" padding-mode="left" padding-char="0" />
    18. 

  18. 		<field id="systemsTraceAuditNumber" bit="11" type="string" length="6" />
    19. 

  19. 		<field id="timeLocalTransaction" bit="12" type="string" length="6" />
    20. 

  20. 		<field id="dateLocalTransaction" bit="13" type="string" length="4" />
    21. 

  21. 		<field id="dateExpiration" bit="14" type="string" length="4" />
    22. 

  22. 		<field id="dateSettlement" bit="15" type="string" length="4" />
    23. 

  23. 		<field id="dateConversion" bit="16" type="string" length="4" />
    24. 

  24. 		<field id="dateCapture" bit="17" type="string" length="4" />
    25. 

  25. 		<field id="merchantType" bit="18" type="string" length="4" padding-mode="left" padding-char="0" />
    26. 

  26. 		<field id="acquiringInstitutionCountryCode" bit="19" type="string" length="3" padding-mode="left" padding-char="0" />
    27. 

  27. 		<field id="panExtendedCountryCode" bit="20" type="string" length="3" padding-mode="left" padding-char="0" />
    28. 

  28. 		<field id="forwardingInstitutionCountryCode" bit="21" type="string" length="3" padding-mode="left" padding-char="0" />
    29. 

  29. 		<field id="pointOfServiceEntryMode" bit="22" type="string" length="3" padding-mode="left" padding-char="0" />
    30. 

  30. 		<field id="applicationPanNumber" bit="23" type="string" length="3" padding-mode="left" padding-char="0" />
    31. 

  31. 		<field id="networkInternationalIdentifier" bit="24" type="string" length="3" padding-mode="left" padding-char="0" />
    32. 

  32. 		<field id="pointOfServiceConditionCode" bit="25" type="string" length="2" padding-mode="left" padding-char="0" />
    33. 

  33. 		<field id="pointOfServiceCaptureCode" bit="26" type="string" length="2" padding-mode="left" padding-char="0" />
    34. 

  34. 		<field id="authorisingIdentificationResponseLength" bit="27" type="string" length="1" padding-mode="left" padding-char="0" />
    35. 

  35. 		<field id="amountTransactionFee" bit="28" type="string" length="9" padding-mode="left" padding-char="0" />
    36. 

  36. 		<field id="amountSettlementFee" bit="29" type="string" length="9" padding-mode="left" padding-char="0" />
    37. 

  37. 		<field id="amountTransactionProcessingFee" bit="30" type="string" length="9" padding-mode="left" padding-char="0" />
    38. 

  38. 		<field id="amountSettlementProcessingFee" bit="31" type="string" length="9" padding-mode="left" padding-char="0" />
    39. 

  39. 		<field id="acquiringInstitutionIdentificationCode" bit="32" type="string" length="11" format="llvar" />
    40. 

  40. 		<field id="forwardingInstitutionIdentificationCode" bit="33" type="string" length="11" format="llvar" />
    41. 

  41. 		<field id="primaryAccountNumberExtended" bit="34" type="string" length="28" format="llvar" />
    42. 

  42. 		<field id="track2Data" bit="35" type="string" length="37" format="llvar" />
    43. 

  43. 		<field id="track3Data" bit="36" type="string" length="104" format="lllvar" />
    44. 

  44. 		<field id="retrievalReferenceNumber" bit="37" type="string" length="12" />
    45. 

  45. 		<field id="authorisationIdentificationResponse" bit="38" type="string" length="6" />  
    46. 

  46. 		<field id="responseCode" bit="39" type="string" length="2" padding-mode="left" />
    47. 

  47. 		<field id="serviceRestrictionCode" bit="40" type="string" length="3" />
    48. 

  48. 		<field id="cardAcceptorTerminalIdentification" bit="41" type="string" length="8" />
    49. 

  49. 		<field id="cardAcceptorIdentificationCode" bit="42" type="string" length="15" />
    50. 

  50. 		<field id="cardAcceptorName" bit="43" type="string" length="40" />
    51. 

  51. 		<field id="additionalResponseData" bit="44" type="string" length="25" format="llvar" />
    52. 

  52. 		<field id="track1Data" bit="45" type="string" length="76" format="llvar" />
    53. 

  53. 		<field id="additionalDataIso" bit="46" type="string" length="999" format="lllvar" />
    54. 

  54. 		<field id="additionalDataNational" bit="47" type="string" length="999" format="lllvar" />
    55. 

  55. 		<field id="additionalDataPrivate" bit="48" type="string" length="999" format="lllvar" />
    56. 

  56. 		<field id="currencyCodeTransaction" bit="49" type="string" length="3" />
    57. 

  57. 		<field id="currencyCodeSettlement" bit="50" type="string" length="3" />
    58. 

  58. 		<field id="currencyCodeCardholderBilling" bit="51" type="string" length="3" />
    59. 

  59. 		<field id="personalIdentificationNumberData" bit="52" type="string" length="16" />
    60. 

  60. 		<field id="securityRelatedControlInformation" bit="53" type="string" length="18" padding-mode="left" padding-char="0" />
    61. 

  61. 		<field id="additionalAmounts" bit="54" type="string" length="999" format="lllvar" />
    62. 

  62. 		<field id="reservedIso1" bit="55" type="string" length="999" format="lllvar" />
    63. 

  63. 		<field id="reservedIso2" bit="56" type="string" length="999" format="lllvar" />
    64. 

  64. 		<field id="reservedNational1" bit="57" type="string" length="999" format="lllvar" />
    65. 

  65. 		<field id="reservedNational2" bit="58" type="string" length="999" format="lllvar" />
    66. 

  66. 		<field id="reservedNational3" bit="59" type="string" length="999" format="lllvar" />
    67. 

  67. 		<field id="reasonCode" bit="60" type="string" length="999" format="lllvar" />
    68. 

  68. 		<field id="reservedPrivate1" bit="61" type="string" length="999" format="lllvar" />
    69. 

  69. 		<field id="reservedPrivate2" bit="62" type="string" length="999" format="lllvar" />
    70. 

  70. 		<field id="reservedPrivate3" bit="63" type="string" length="999" format="lllvar" />
    71. 

  71. 		<field id="messageAuthenticationCode" bit="64" type="string" length="16" />
    72. 

  72. 		<field id="bitMapTertiary" bit="65" type="string" length="16" />
    73. 

  73. 		<field id="settlementCode" bit="66" type="string" length="1" padding-mode="left" padding-char="0" />
    74. 

  74. 		<field id="extendedPaymentCode" bit="67" type="string" length="2" padding-mode="left" padding-char="0" />
    75. 

  75. 		<field id="receivingInstitutionCountryCode" bit="68" type="string" length="3" />
    76. 

  76. 		<field id="settlementInstitutionCountyCode" bit="69" type="string" length="3" />
    77. 

  77. 		<field id="networkManagementInformationCode" bit="70" type="string" length="3" />
    78. 

  78. 		<field id="messageNumber" bit="71" type="string" length="4" padding-mode="left" padding-char="0" />
    79. 

  79. 		<field id="messageNumberLast" bit="72" type="string" length="4" padding-mode="left" padding-char="0" />
    80. 

  80. 		<field id="dateAction" bit="73" type="string" length="6" />
    81. 

  81. 		<field id="creditsNumber" bit="74" type="string" length="10" padding-mode="left" padding-char="0" />
    82. 

  82. 		<field id="creditsReversalNumber" bit="75" type="string" length="10" padding-mode="left" padding-char="0" />
    83. 

  83. 		<field id="debitsNumber" bit="76" type="string" length="10" padding-mode="left" padding-char="0" />
    84. 

  84. 		<field id="debitsReversalNumber" bit="77" type="string" length="10" padding-mode="left" padding-char="0" />
    85. 

  85. 		<field id="transferNumber" bit="78" type="string" length="10" padding-mode="left" padding-char="0" />
    86. 

  86. 		<field id="transferReversalNumber" bit="79" type="string" length="10" padding-mode="left" padding-char="0" />
    87. 

  87. 		<field id="inquiriesNumber" bit="80" type="string" length="10" padding-mode="left" padding-char="0" />
    88. 

  88. 		<field id="authorisationsNumber" bit="81" type="string" length="10" padding-mode="left" padding-char="0" />
    89. 

  89. 		<field id="creditsProcesssingFeeAmount" bit="82" type="string" length="14" padding-mode="left" padding-char="0" />
    90. 

  90. 		<field id="creditsTransactionFeeAmount" bit="83" type="string" length="14" padding-mode="left" padding-char="0" />
    91. 

  91. 		<field id="debitsProcessingFeeAmount" bit="84" type="string" length="14" padding-mode="left" padding-char="0" />
    92. 

  92. 		<field id="debitsTransactionFeeAmount" bit="85" type="string" length="14" padding-mode="left" padding-char="0" />
    93. 

  93. 		<field id="creditsAmount" bit="86" type="string" length="15" padding-mode="left" padding-char="0" />
    94. 

  94. 		<field id="creditsReversalAmount" bit="87" type="string" length="15" padding-mode="left" padding-char="0" />
    95. 

  95. 		<field id="debitsAmount" bit="88" type="string" length="15" padding-mode="left" padding-char="0" />
    96. 

  96. 		<field id="debitsReversalAmount" bit="89" type="string" length="15" padding-mode="left" padding-char="0" />
    97. 

  97. 		<field id="originalDataElements" bit="90" type="string" length="42" padding-mode="left" />
    98. 

  98. 		<field id="fileUpdateCode" bit="91" type="string" length="1" />
    99. 

  99. 		<field id="fileSecurityCode" bit="92" type="string" length="2" padding-mode="left" padding-char="0" />
    100. 

  100. 		<field id="responseIndicator" bit="93" type="string" length="5" padding-mode="left" padding-char="0" />
    101. 

  101. 		<field id="serviceIndicator" bit="94" type="string" length="7" />
    102. 

  102. 		<field id="replacementAmounts" bit="95" type="string" length="42" />
    103. 

  103. 		<field id="messageSecurityCode" bit="96" type="string" length="8" />
    104. 

  104. 		<field id="amountNetSettlement" bit="97" type="string" length="16" padding-mode="left" padding-char="0" />
    105. 

  105. 		<field id="payee" bit="98" type="string" length="25" />
    106. 

  106. 		<field id="settlementInstitutionIdentificationCode" bit="99" type="string" length="11" format="llvar" />
    107. 

  107. 		<field id="receivingInstitutionIdentificationCode" bit="100" type="string" length="11" format="llvar" />
    108. 

  108. 		<field id="slipNumber" bit="101" type="string" length="11" format="llvar" />
    109. 

  109. 		<field id="fromAccount" bit="102" type="string" length="19" format="llvar" />
    110. 

  110. 		<field id="toAccount" bit="103" type="string" length="28" format="llvar" />
    111. 

  111. 		<field id="transactionDescription" bit="104" type="string" length="100" format="lllvar" />
    112. 

  112. 		<field id="reservedForIsoUse1" bit="105" type="string" length="999" format="lllvar" />
    113. 

  113. 		<field id="reservedForIsoUse2" bit="106" type="string" length="999" format="lllvar" />
    114. 

  114. 		<field id="reservedForIsoUse3" bit="107" type="string" length="999" format="lllvar" />
    115. 

  115. 		<field id="reservedForIsoUse4" bit="108" type="string" length="999" format="lllvar" />
    116. 

  116. 		<field id="reservedForIsoUse5" bit="109" type="string" length="999" format="lllvar" />
    117. 

  117. 		<field id="reservedForIsoUse6" bit="110" type="string" length="999" format="lllvar" />
    118. 

  118. 		<field id="reservedForIsoUse7" bit="111" type="string" length="999" format="lllvar" />
    119. 

  119. 		<field id="reservedForNationalUse" bit="112" type="string" length="999" format="lllvar" />
    120. 

  120. 		<field id="authorisingAgentInstitutionIdCode" bit="113" type="string" length="11" format="llvar" />
    121. 

  121. 		<field id="reservedForNationalUse1" bit="114" type="string" length="999" format="lllvar" />
    122. 

  122. 		<field id="reservedForNationalUse2" bit="115" type="string" length="999" format="lllvar" />
    123. 

  123. 		<field id="reservedForNationalUse3" bit="116" type="string" length="999" format="lllvar" />
    124. 

  124. 		<field id="reservedForNationalUse4" bit="117" type="string" length="999" format="lllvar" />
    125. 

  125. 		<field id="reservedForNationalUse5" bit="118" type="string" length="999" format="lllvar" />
    126. 

  126. 		<field id="reservedForNationalUse6" bit="119" type="string" length="999" format="lllvar" />
    127. 

  127. 		<field id="reservedForPrivateUse1" bit="120" type="string" length="999" format="lllvar" />
    128. 

  128. 		<field id="reservedForPrivateUse2" bit="121" type="string" length="999" format="lllvar" />
    129. 

  129. 		<field id="reservedForPrivateUse3" bit="122" type="string" length="999" format="lllvar" />
    130. 

  130. 		<field id="reservedForPrivateUse4" bit="123" type="string" length="999" format="lllvar" />
    131. 

  131. 		<field id="infoText" bit="124" type="string" length="255" format="lllvar" />
    132. 

  132. 		<field id="networkManagementInformation" bit="125" type="string" length="50" format="lllvar" />
    133. 

  133. 		<field id="issuerTraceId" bit="126" type="string" length="6" format="lllvar" />
    134. 

  134. 		<field id="reservedForPrivateUse" bit="127" type="string" length="11" format="lllvar" />
    135. 

  135. 		<field id="messageAuthenticationCode2" bit="128" type="string" length="16" />
    136. 

  136. 	</field>
    137. 

  137. 	<field id="!type" type="script" encode="true">iso-8583-cws</field>
    138. 

  138. 	<field id="!mid" type="script" encode="true">${msg.transmissionDateTime}.${msg.systemsTraceAuditNumber}</field>
    139. 

  139. 	<field id="!code" type="script" encode="true">${msg.messageType}.${msg.messageType.startsWith("08") ? msg.networkManagementInformationCode?.padLeft(6, "0") : msg.processingCode?.trim().substring(0,6)}</field>
    140. 

  140. </codex>', CURRENT USER, CURRENT TIMESTAMP);
    141. 

  141. 

  142. INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID)
    143. 

  143. 	VALUES ('dic-30801', 'incoming', 'iso-8583-cws');
    144. 

  144. INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID)
    145. 

  145. 	VALUES ('dic-30801', 'outgoing', 'iso-8583-cws');
    146. 

  146. 

  147. INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE)
    148. 

  148. 	VALUES ('dic-30801', 'maxConnection', '1');
    149. 

  149. 

  150. INSERT INTO MWCONFIG.SERVER_PORT (ADAPTOR_ID, PORT, SERVER, GROUP)
    151. 

  151. 	VALUES ('dic-30801', 30801, 'dummy-server', 'dic');
    152. 

  152. 

  153. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.default-mapping', NULL, '[dic]', CURRENT USER, CURRENT TIMESTAMP);
    154. 

  154. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
    155. 

  155. 	VALUES 
    156. 

  156. 		('dummy-res.dic.default-mapping', 1, '/data', '/data', NULL, NULL),
    157. 

  157. 		('dummy-res.dic.default-mapping', 2, '/data/body', '/data/body', NULL, NULL);
    158. 

  158. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
    159. 

  159. 	VALUES 
    160. 

  160. 		('dummy-res.dic.default-mapping', 1, '@', 'copyMessage();', NULL),
    161. 

  161. 		('dummy-res.dic.default-mapping', 2, 'messageType', '${msg.messageType.''!value''.substring(0,2).concat("10")}', NULL),
    162. 

  162. 		('dummy-res.dic.default-mapping', 2, 'responseCode', '00', NULL);
    163. 

  163. 

  164. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.default-transaction-mapping', NULL, '[dic]', CURRENT USER, CURRENT TIMESTAMP);
    165. 

  165. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
    166. 

  166. 	VALUES ('dummy-res.dic.default-transaction-mapping', 3, '/data/body', '/data/body', NULL, NULL);
    167. 

  167. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
    168. 

  168. 	VALUES 
    169. 

  169. 		('dummy-res.dic.default-transaction-mapping', 3, 'dateCapture', '${msg.dateLocalTransaction}', NULL),
    170. 

  170. 		('dummy-res.dic.default-transaction-mapping', 3, 'reservedPrivate1', 'BTN4PRO100000000000', NULL),
    171. 

  171. 		('dummy-res.dic.default-transaction-mapping', 3, 'receivingInstitutionIdentificationCode', '20000000001', NULL);
    172. 

  172. 

  173. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.0800.000001', 'SIGN ON', '[dic]', CURRENT USER, CURRENT TIMESTAMP);
    174. 

  174. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
    175. 

  175. 	VALUES 
    176. 

  176. 		('dummy-res.dic.0800.000001', 1, '/data', '/data', 'dummy-res.dic.default-mapping', 1),
    177. 

  177. 		('dummy-res.dic.0800.000001', 2, '/data/body', '/data/body', 'dummy-res.dic.default-mapping', 2);
    178. 

  178. 

  179. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.0800.000301', 'ECHO TEST', '[dic]', CURRENT USER, CURRENT TIMESTAMP);
    180. 

  180. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
    181. 

  181. 	VALUES 
    182. 

  182. 		('dummy-res.dic.0800.000301', 1, '/data', '/data', 'dummy-res.dic.default-mapping', 1),
    183. 

  183. 		('dummy-res.dic.0800.000301', 2, '/data/body', '/data/body', 'dummy-res.dic.default-mapping', 2);
    184. 

  184. 

  185. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.0200.022000', NULL, '[dic]', CURRENT USER, CURRENT TIMESTAMP);
    186. 

  186. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
    187. 

  187. 	VALUES 
    188. 

  188. 		('dummy-res.dic.0200.022000', 1, '/data', '/data', 'dummy-res.dic.default-mapping', 1),
    189. 

  189. 		('dummy-res.dic.0200.022000', 2, '/data/body', '/data/body', 'dummy-res.dic.default-mapping', 2),
    190. 

  190. 		('dummy-res.dic.0200.022000', 3, '/data/body', '/data/body', 'dummy-res.dic.default-transaction-mapping', 3);
    191. 

  191. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
    192. 

  192. 	VALUES 
    193. 

  193. 		('dummy-res.dic.0200.022000', 2, 'responseCode', '00', 10);
    194. 

  194. 

  195. 

  196. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.0200.940000', NULL, '[dic]', CURRENT USER, CURRENT TIMESTAMP);
    197. 

  197. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
    198. 

  198. 	VALUES 
    199. 

  199. 		('dummy-res.dic.0200.940000', 1, '/data', '/data', 'dummy-res.dic.default-mapping', 1),
    200. 

  200. 		('dummy-res.dic.0200.940000', 2, '/data/body', '/data/body', 'dummy-res.dic.default-mapping', 2),
    201. 

  201. 		('dummy-res.dic.0200.940000', 3, '/data/body', '/data/body', 'dummy-res.dic.default-transaction-mapping', 3);
    202. 

  202. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
    203. 

  203. 	VALUES 
    204. 

  204. 		('dummy-res.dic.0200.940000', 2, 'responseCode', '00', 10);
    205. 

  205. 

  206. -- CLIENT TARGET
    207. 

  207. 

  208. INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, TIMESTAMP)
    209. 

  209.     VALUES ('ist-conn', NULL, 1, CURRENT USER, CURRENT TIMESTAMP);
    210. 

  210. INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID)
    211. 

  211.     VALUES 
    212. 

  212.         ('ist-conn', 'incoming', 'iso-8583-cws'),
    213. 

  213.         ('ist-conn', 'outgoing', 'iso-8583-cws');
    214. 

  214. INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE)
    215. 

  215.     VALUES
    216. 

  216.         ('ist-conn', 'echo', '60000'),
    217. 

  217.         ('ist-conn', 'needSignOn', 'true'),
    218. 

  218.         ('ist-conn', 'timeout', '60000');
    219. 

  219. 

  220. INSERT INTO MWCONFIG.CLIENT (ADAPTOR_ID, IDLE_WAIT, TIMEOUT, CLOSE_QUEUE, CONTROL_QUEUE, KEEP_CONN, REUSE_DELAY, NODE)
    221. 

  221.     VALUES('ist-conn', 0, 0, NULL, NULL, 1, 0, 'backend-iso');
    222. 

  222. INSERT INTO MWCONFIG.CLIENT_TARGET (CLIENT_ID, ID, HOST, WEIGHT, SEQ)
    223. 

  223.     VALUES ('ist-conn', 'ist-conn', 'DUMMY:30801', 0, 1);
    224. 

  224. 

  225. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('ist-conn.SIGN-ON', null, CURRENT USER, CURRENT TIMESTAMP);
    226. 

  226. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    227. 

  227.     VALUES ('ist-conn.SIGN-ON', 1, '/data', '/data/body', NULL, NULL);
    228. 

  228. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    229. 

  229.     VALUES 
    230. 

  230.         ('ist-conn.SIGN-ON', 1, 'systemsTraceAuditNumber', '${counter("ist-conn", 5, 1, "ddMMyy")} ', 10),
    231. 

  231.         ('ist-conn.SIGN-ON', 1, 'transmissionDateTime', '${getTimeZoneFormat("MMddHHmmss","GMT")}', 10),
    232. 

  232.         ('ist-conn.SIGN-ON', 1, '!mid', '${tar.transmissionDateTime."!value"+"."+tar.systemsTraceAuditNumber."!value"}', 20),
    233. 

  233.         ('ist-conn.SIGN-ON', 1, '!destination', '${msg.source}', null),
    234. 

  234.         ('ist-conn.SIGN-ON', 1, '!nosignon', 'true', null),
    235. 

  235.         ('ist-conn.SIGN-ON', 1, '!reqtimestamp', '${head.reqtimestamp}', null),
    236. 

  236.         ('ist-conn.SIGN-ON', 1, '!sid', '${msg.sid}', null),
    237. 

  237.         ('ist-conn.SIGN-ON', 1, 'dateLocalTransaction', '${getTimeZoneFormat("MMdd","GMT")}', null),
    238. 

  238.         ('ist-conn.SIGN-ON', 1, 'messageType', '0800', null),
    239. 

  239.         ('ist-conn.SIGN-ON', 1, 'networkManagementInformationCode', '001', null),
    240. 

  240.         ('ist-conn.SIGN-ON', 1, 'timeLocalTransaction', '${getTimeZoneFormat("HHmmss","GMT")}', null);
    241. 

  241. 

  242. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('ist-conn.ECHO-TEST', null, CURRENT USER, CURRENT TIMESTAMP);
    243. 

  243. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    244. 

  244.     VALUES 
    245. 

  245. 	('ist-conn.ECHO-TEST', 1, '/data', '/data/body', 'ist-conn.SIGN-ON', '1');
    246. 

  246. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    247. 

  247.     VALUES 
    248. 

  248. 	('ist-conn.ECHO-TEST', 1, 'networkManagementInformationCode', '301', null);
    249. 

  249. 

  250.