INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, "TIMESTAMP") VALUES('bi-conn-konven', 'BI Fast Connector', 1, 'wpsadmin', '2022-01-19 09:19:11.020000'); INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, "TIMESTAMP") VALUES('bi-conn-syariah', 'BI Fast Connector', 1, 'wpsadmin', '2022-01-19 09:20:21.119000'); INSERT INTO MWCONFIG.CODEX (ID, ALLOW_PARTIAL, "XML", MODIFIED_BY, "TIMESTAMP") VALUES('iso-8583-bi-conn', 1, ' iso-8583-bi-conn ${msg.transmissionDateTime}.${msg.systemsTraceAuditNumber} ${msg.messageType}.${msg.messageType.startsWith("08") ? msg.networkManagementInformationCode?.padLeft(6, "0") : msg.processingCode?.trim()} ', 'DB2PROD ', '2021-12-17 16:19:19.711712'); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES('bi-conn-konven', 'incoming', 'iso-8583-bi-conn'); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES('bi-conn-konven', 'outgoing', 'iso-8583-bi-conn'); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES('bi-conn-syariah', 'incoming', 'iso-8583-bi-conn'); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES('bi-conn-syariah', 'outgoing', 'iso-8583-bi-conn'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('bi-conn-konven', 'echo', '3600000'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('bi-conn-konven', 'needSignOn', 'true'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('bi-conn-konven', 'timeout', '60000'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('bi-conn-syariah', 'echo', '3600000'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('bi-conn-syariah', 'needSignOn', 'true'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('bi-conn-syariah', 'timeout', '60000'); INSERT INTO MWCONFIG.CLIENT (ADAPTOR_ID, IDLE_WAIT, TIMEOUT, CLOSE_QUEUE, CONTROL_QUEUE, KEEP_CONN, REUSE_DELAY, NODE) VALUES('bi-conn-konven', 0, 0, NULL, NULL, 1, 0, 'backend-iso'); INSERT INTO MWCONFIG.CLIENT (ADAPTOR_ID, IDLE_WAIT, TIMEOUT, CLOSE_QUEUE, CONTROL_QUEUE, KEEP_CONN, REUSE_DELAY, NODE) VALUES('bi-conn-syariah', 0, 0, NULL, NULL, 1, 0, 'backend-iso'); INSERT INTO MWCONFIG.CLIENT_TARGET (CLIENT_ID, ID, HOST, WEIGHT, SEQ) VALUES('bi-conn-konven', 'bi-conn-konven', 'localhost:13067', 1, 0); INSERT INTO MWCONFIG.CLIENT_TARGET (CLIENT_ID, ID, HOST, WEIGHT, SEQ) VALUES('bi-conn-syariah', 'bi-conn-syariah', 'localhost:8357', 1, 0); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODIFIED_BY, "TIMESTAMP", MODULE) VALUES('bi-conn-konven.SIGN-ON', NULL, 'DB2PROD ', '2021-12-17 16:20:21.982167', ''); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODIFIED_BY, "TIMESTAMP", MODULE) VALUES('bi-conn-konven.ECHO-TEST', NULL, 'DB2PROD ', '2021-12-17 16:20:22.008627', ''); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODIFIED_BY, "TIMESTAMP", MODULE) VALUES('bi-conn-syariah.SIGN-ON', NULL, 'DB2PROD ', '2021-12-17 16:20:22.436100', ''); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODIFIED_BY, "TIMESTAMP", MODULE) VALUES('bi-conn-syariah.ECHO-TEST', NULL, 'DB2PROD ', '2021-12-17 16:20:22.462368', ''); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES('bi-conn-konven.SIGN-ON', 1, '/data', '/data/body', NULL, NULL); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES('bi-conn-konven.ECHO-TEST', 1, '/data', '/data/body', 'bi-conn-konven.SIGN-ON', 1); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES('bi-conn-syariah.SIGN-ON', 1, '/data', '/data/body', NULL, NULL); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES('bi-conn-syariah.ECHO-TEST', 1, '/data', '/data/body', 'bi-conn-syariah.SIGN-ON', 1); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-konven.SIGN-ON', 1, '@', 'copyMessage();', 5); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-konven.SIGN-ON', 1, 'transmissionDateTime', '${getTimeZoneFormat("MMddHHmmss","GMT")}', 10); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-konven.SIGN-ON', 1, 'systemsTraceAuditNumber', '${counter("bi-conn-konven", 5, 1, "ddMMyy")}', 10); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-konven.SIGN-ON', 1, '!mid', '${tar.transmissionDateTime."!value"+"."+tar.systemsTraceAuditNumber."!value"}', 20); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-konven.SIGN-ON', 1, '!sid', '${getUID(tar.transmissionDateTime."!value"+"."+tar.systemsTraceAuditNumber."!value")}', 20); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-konven.SIGN-ON', 1, '!destination', 'bi-conn-konven', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-konven.SIGN-ON', 1, '!nosignon', 'true', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-konven.SIGN-ON', 1, 'messageType', '0800', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-konven.SIGN-ON', 1, 'networkManagementInformationCode', '001', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-konven.ECHO-TEST', 1, 'networkManagementInformationCode', '301', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-syariah.SIGN-ON', 1, '@', 'copyMessage();', 5); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-syariah.SIGN-ON', 1, 'transmissionDateTime', '${getTimeZoneFormat("MMddHHmmss","GMT")}', 10); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-syariah.SIGN-ON', 1, 'systemsTraceAuditNumber', '${counter("bi-conn-syariah", 5, 1, "ddMMyy")}', 10); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-syariah.SIGN-ON', 1, '!mid', '${tar.transmissionDateTime."!value"+"."+tar.systemsTraceAuditNumber."!value"}', 20); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-syariah.SIGN-ON', 1, '!sid', '${getUID(tar.transmissionDateTime."!value"+"."+tar.systemsTraceAuditNumber."!value")}', 20); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-syariah.SIGN-ON', 1, '!destination', 'bi-conn-syariah', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-syariah.SIGN-ON', 1, '!nosignon', 'true', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-syariah.SIGN-ON', 1, 'messageType', '0800', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-syariah.SIGN-ON', 1, 'networkManagementInformationCode', '001', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('bi-conn-syariah.ECHO-TEST', 1, 'networkManagementInformationCode', '301', NULL);