1
0

MWCONFIG_INITDB_DUMMY_CORE_KONVEN.sql 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184
  1. INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, TIMESTAMP)
  2. VALUES ('dck-13000', 'Dummy Core Konven', 0, CURRENT USER, CURRENT TIMESTAMP);
  3. INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID)
  4. VALUES ('dck-13000', 'incoming', 'dsp');
  5. INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID)
  6. VALUES ('dck-13000', 'outgoing', 'dsp-response');
  7. INSERT INTO MWCONFIG.SERVER_PORT (ADAPTOR_ID, PORT, SERVER, GROUP)
  8. VALUES ('dck-13000', 13000, 'dummy-server', 'dck');
  9. INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
  10. VALUES ('dummy-res.dck.master', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
  11. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  12. VALUES ('dummy-res.dck.master', 1, '/data/body', '/data/body', NULL, NULL);
  13. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
  14. VALUES ('dummy-res.dck.master', 1, '!CorrelId', '${head.CorrelId}'),
  15. ('dummy-res.dck.master', 1, '!sid', '${head.sid}'),
  16. ('dummy-res.dck.master', 1, '!connid', '${head.connid}'),
  17. ('dummy-res.dck.master', 1, '!group', '${head.group}'),
  18. ('dummy-res.dck.master', 1, '!source', '${head.source}'),
  19. ('dummy-res.dck.master', 1, '!dir', 'O'),
  20. ('dummy-res.dck.master', 1, '!reqtimestamp', '${head.reqtimestamp}'),
  21. ('dummy-res.dck.master', 1, 'dspHeaderType', '*SOKI'),
  22. ('dummy-res.dck.master', 1, 'dspSocketNumber', '1'),
  23. ('dummy-res.dck.master', 1, 'dspPortNumber', '13000'),
  24. ('dummy-res.dck.master', 1, 'dspFiller1', '40'),
  25. ('dummy-res.dck.master', 1, 'dspHeaderLength', '213'),
  26. ('dummy-res.dck.master', 1, 'dspVersionNumber', '0200'),
  27. ('dummy-res.dck.master', 1, 'dspHeaderFormatId', '*DSP'),
  28. ('dummy-res.dck.master', 1, 'dspDataFormatId', '${msg.dspDataFormatId}'),
  29. ('dummy-res.dck.master', 1, 'dspSourceId', '${msg.dspSourceId}'),
  30. ('dummy-res.dck.master', 1, 'dspDestinationId', 'DQAXISIN'),
  31. ('dummy-res.dck.master', 1, 'dspRoutingNumber', '00'),
  32. ('dummy-res.dck.master', 1, 'dspMessageStatus', '/-------'),
  33. ('dummy-res.dck.master', 1, 'dspBankIdNumber', '${msg.dspBankIdNumber}'),
  34. ('dummy-res.dck.master', 1, 'dspNode', '${msg.dspNode}'),
  35. ('dummy-res.dck.master', 1, 'dspExchangeId', '000000002F07001F4040C3D4D5E2C2D9F0F0F0F1'),
  36. ('dummy-res.dck.master', 1, 'dspScenarioNumber', '${msg.dspScenarioNumber}'),
  37. ('dummy-res.dck.master', 1, 'dspTransactionCode', '${msg.dspTransactionCode}'),
  38. ('dummy-res.dck.master', 1, 'dspRetrievalReferenceNumber', '1234567890123456789012'),
  39. ('dummy-res.dck.master', 1, 'dspNumberOfRecordsToBeLoaded', '10'),
  40. ('dummy-res.dck.master', 1, 'dspNumberOfErrorsToBeLoaded', '10'),
  41. ('dummy-res.dck.master', 1, 'dspUserId', '${msg.dspUserId}'),
  42. ('dummy-res.dck.master', 1, 'dspTerminalId', '${msg.dspTerminalId}');
  43. INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
  44. VALUES ('dummy-res.dck.master-abcs', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
  45. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  46. VALUES ('dummy-res.dck.master-abcs', 1, '/data/body', '/data/body', 'dummy-res.dck.master', 1);
  47. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
  48. VALUES ('dummy-res.dck.master-abcs', 1, 'ICHEAD', '*SOKR'),
  49. ('dummy-res.dck.master-abcs', 1, 'ICRTRQ', 'DQICRTTEL'),
  50. ('dummy-res.dck.master-abcs', 1, 'ICDEVN', '${msg.ICDEVN}'),
  51. ('dummy-res.dck.master-abcs', 1, 'ICID', '12345'),
  52. ('dummy-res.dck.master-abcs', 1, 'ICCOMQ', 'DQAXISIN'),
  53. ('dummy-res.dck.master-abcs', 1, 'TMTIMIN', '${new java.text.SimpleDateFormat("HHmmss").format(new Date())}'),
  54. ('dummy-res.dck.master-abcs', 1, 'TMTXTYP', '${msg.TMTXTYP}'),
  55. ('dummy-res.dck.master-abcs', 1, 'ICEOM', '${msg.ICEOM}'),
  56. ('dummy-res.dck.master-abcs', 1, 'tellerID', '${msg.TLBID}'),
  57. ('dummy-res.dck.master-abcs', 1, 'sequenceNumber', '${msg.TLBJSN}');
  58. INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
  59. VALUES ('dummy-res.dck.master-abcs-89', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
  60. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  61. VALUES ('dummy-res.dck.master-abcs-89', 1, '/data/body', '/data/body', 'dummy-res.dck.master', 1);
  62. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
  63. VALUES ('dummy-res.dck.master-abcs-89', 1, 'responseCode_89', '89'),
  64. ('dummy-res.dck.master-abcs-89', 1, 'responseHeader_89', '89'),
  65. ('dummy-res.dck.master-abcs-89', 1, 'responseSubHeader_89', 'F1');
  66. INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
  67. VALUES ('dummy-res.dck.master-abcs-F1', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
  68. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  69. VALUES ('dummy-res.dck.master-abcs-F1', 1, '/data/body', '/data/body', 'dummy-res.dck.master', 1);
  70. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
  71. VALUES ('dummy-res.dck.master-abcs-F1', 1, 'responseCode_F1', 'F1'),
  72. ('dummy-res.dck.master-abcs-F1', 1, 'responseHeader_F1', 'F1'),
  73. ('dummy-res.dck.master-abcs-F1', 1, 'TLXMNE_F1', 'INQ');
  74. INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
  75. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
  76. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  77. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1, '/data/body', '/data/body', 'dummy-res.dck.master-abcs', 1),
  78. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, '/data/body', '/data/body', 'dummy-res.dck.master-abcs-89', 1),
  79. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3, '/data/body', '/data/body', 'dummy-res.dck.master-abcs-F1', 1);
  80. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
  81. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1, 'dspMessageLength', '741'),
  82. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1, 'ICLEN', '75'),
  83. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1, 'abcsResponses', '89 F1'),
  84. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, '!multicodex_suffix_1', '_89'),
  85. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'ACCTNO_89', '1601500028153'),
  86. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'ACTYPE_89', 'S'),
  87. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'SNAME_89', 'SUCIPTO'),
  88. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'CFSSNO_89', '1055101502651003'),
  89. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'STATUS_89', '1'),
  90. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'CBAL_89', '27260729942.98'),
  91. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'COLECT_89', '27260729942.98'),
  92. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'WHYTD_89', '138731996.73'),
  93. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'WHTDY_89', '8962430'),
  94. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'ACCRU2_89', '44812159'),
  95. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'NETAMT_89', '27296579671.98'),
  96. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'PBBAL_89', '3348239020.92'),
  97. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'TLNBSR_89', '3405'),
  98. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'UNPAMT_89', '23912490922.06'),
  99. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'UNPITM_89', '66'),
  100. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'DDSIC1_89', 'D5'),
  101. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'DDSIC2_89', 'D5'),
  102. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'DDSIC3_89', 'D5'),
  103. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'DDSIC4_89', 'D5'),
  104. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'AVLBAL_89', '27260729942.98'),
  105. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'MINBLM_89', '50000'),
  106. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3, '!multicodex_suffix_2', '_F1'),
  107. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3, 'SNAME_F1', 'SUCIPTO'),
  108. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3, 'AMT1_F1', '27260729942.98'),
  109. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3, 'AMT2_F1', '27260729942.98');
  110. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP)
  111. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', NULL, '[dck]', CURRENT USER, CURRENT TIMESTAMP);
  112. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  113. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 1, '/data/body', '/data/body', 'dummy-res.dck.master-abcs', 1),
  114. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, '/data/body', '/data/body', 'dummy-res.dck.master-abcs-F1', 1);
  115. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
  116. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 1, 'ICLEN', '98', NULL),
  117. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 1, 'dspMessageLength', '349', NULL),
  118. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, '!multicodex_suffix_1', '_F1', NULL),
  119. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, 'ACC_F1', '29816151200', NULL),
  120. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, 'AMT1_F1', '298161512', NULL),
  121. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, 'AMT2_F1', '298161512', NULL),
  122. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, 'SNAME_F1', 'NASABAH A000008', NULL),
  123. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, 'TLXMNE_F1', 'PBK', NULL);
  124. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP)
  125. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', NULL, '[dck]', CURRENT USER, CURRENT TIMESTAMP);
  126. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  127. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 1, '/data/body', '/data/body', 'dummy-res.dck.master-abcs', 1),
  128. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, '/data/body', '/data/body', 'dummy-res.dck.master-abcs-F1', 1);
  129. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
  130. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 1, 'ICLEN', '98', NULL),
  131. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 1, 'dspMessageLength', '349', NULL),
  132. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, '!multicodex_suffix_1', '_F1', NULL),
  133. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, 'ACC_F1', '29816151200', NULL),
  134. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, 'AMT1_F1', '298161512', NULL),
  135. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, 'AMT2_F1', '298161512', NULL),
  136. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, 'SNAME_F1', 'NASABAH A000008', NULL),
  137. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, 'TLXMNE_F1', 'PBK', NULL);
  138. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP)
  139. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', NULL, '[dck]', CURRENT USER, CURRENT TIMESTAMP);
  140. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  141. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 1, '/data/body', '/data/body', 'dummy-res.dck.master-abcs', 1),
  142. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, '/data/body', '/data/body', 'dummy-res.dck.master-abcs-F1', 1);
  143. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
  144. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 1, 'ICLEN', '98', NULL),
  145. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 1, 'dspMessageLength', '349', NULL),
  146. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, '!multicodex_suffix_1', '_F1', NULL),
  147. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, 'ACC_F1', '29816151200', NULL),
  148. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, 'AMT1_F1', '298161512', NULL),
  149. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, 'AMT2_F1', '298161512', NULL),
  150. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, 'SNAME_F1', 'NASABAH A000008', NULL),
  151. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, 'TLXMNE_F1', 'PBK', NULL);
  152. INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
  153. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005002', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
  154. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  155. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005002', 1, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1),
  156. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005002', 2, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2),
  157. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005002', 3, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3);
  158. INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
  159. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000007140', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
  160. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  161. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000007140', 1, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1),
  162. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000007140', 2, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2),
  163. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000007140', 3, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3);
  164. INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
  165. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005195', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
  166. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  167. VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005195', 1, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1),
  168. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005195', 2, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2),
  169. ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005195', 3, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3);