INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, "TIMESTAMP") VALUES('pemko-depok-conn', 'connector/adaptor untuk pemerintah kota depok', 1, 'wpsadmindev', '2022-02-07 12:57:15.725000'); INSERT INTO MWCONFIG.CODEX (ID, ALLOW_PARTIAL, "XML", MODIFIED_BY, "TIMESTAMP") VALUES('iso-8583-pemkot-depok', NULL, ' iso-8583-pemkot-depok ${msg.systemsTraceAuditNumber} ${msg.messageType}.${msg.messageType.startsWith("08") ? msg.networkManagementInformationCode?.padLeft(6, "0") : msg.processingCode?.trim().substring(0,1)} ', 'wpsadmin', '2014-12-04 14:07:13.031394'); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES('pemko-depok-conn', 'incoming', 'iso-8583-pemkot-depok'); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES('pemko-depok-conn', 'outgoing', 'iso-8583-pemkot-depok'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('pemko-depok-conn', 'echo', '120000'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('pemko-depok-conn', 'needSignOn', 'TRUE'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('pemko-depok-conn', 'timeout', '60000'); INSERT INTO MWCONFIG.CLIENT (ADAPTOR_ID, IDLE_WAIT, TIMEOUT, CLOSE_QUEUE, CONTROL_QUEUE, KEEP_CONN, REUSE_DELAY, NODE) VALUES('pemko-depok-conn', 0, 0, NULL, NULL, 1, 0, 'billpayClientNode'); INSERT INTO MWCONFIG.CLIENT_TARGET (CLIENT_ID, ID, HOST, WEIGHT, SEQ) VALUES('pemko-depok-conn', 'pemko-depok-conn', 'localhost:13063', 0, 1); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODIFIED_BY, "TIMESTAMP", MODULE) VALUES('pemko-depok-conn.ECHO-TEST', '', 'DB2PROD ', '2017-05-24 11:29:20.779458', '[zsym]'); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODIFIED_BY, "TIMESTAMP", MODULE) VALUES('pemko-depok-conn.SIGN-ON', NULL, 'DB2PROD ', '2017-05-24 07:31:03.323678', '[zsym]'); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES('pemko-depok-conn.SIGN-ON', 1, '/data', '/data/body', NULL, NULL); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES('pemko-depok-conn.SIGN-ON', 2, '/data', '/data/body', 'pemko-depok-conn.SIGN-ON', 1); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES('pemko-depok-conn.ECHO-TEST', 1, '/data', '/data/body', 'pemko-depok-conn.SIGN-ON', 2); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.ECHO-TEST', 1, 'networkManagementInformationCode', '301', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 1, 'messageType', '0800', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 1, 'networkManagementInformationCode', '001', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 1, 'systemsTraceAuditNumber', '${counter("pemko-depok-conn", 5, 1, "ddMMyy")}', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 1, 'transmissionDateTime', '${getTimeZoneFormat(''MMddHHmmss'',''GMT'')}', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 2, '!destination', 'pemko-depok-conn', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 2, '!mid', '${tar.systemsTraceAuditNumber.''!value''}', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 2, '!nosignon', 'true', NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 2, '!sid', '${msg.sid==null?getUID(tar.systemsTraceAuditNumber.''!value''):msg.sid.''!value''}', NULL);