Kezdőlap Felfedezés Súgó
Bejelentkezés
fiqri
/
btn-mdw-ace-server-local
1
0
Másolás 0
Fájlok Problémák 0 Beolvasztási kérések 0 Wiki
Branch: master
Branch-ok Tag-ek
btn-mdw-ace-ser...
/
mwlog
/
migration
/
MWLOG_INITDB.sql

MWLOG_INITDB.sql 15 KB
Állandó hivatkozás Előzmények Nyers

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156 
  1. INSERT INTO MWLOG.DLOG_MD (TYPE, PBASE, MODIFIED_BY, TIMESTAMP)
    2. 

  2. 	VALUES ('*', '.', CURRENT USER, CURRENT TIMESTAMP);
    3. 

  3. 

  4. INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
    5. 

  5. 	VALUES ('dsp-abcs-request', 'dsp', NULL, CURRENT USER, CURRENT TIMESTAMP);
    6. 

  6. UPDATE MWLOG.DLOG_MD SET CODEX = 'dsp'	
    7. 

  7. 						, C_11 = 'SEQUENCE_NUMBER', P_11 = 'TLBJSN'
    8. 

  8. 						, C_12 = 'TELLER_ID', P_12 = 'dspUserId'
    9. 

  9. 						, C_13 = 'WORKSTATION_ID', P_13 = 'dspTerminalId'
    10. 

  10. 						, C_14 = 'CONTROL_UNIT', P_14 = 'TLBCUD'
    11. 

  11. 						, C_15 = 'IP_ADDRESS', P_15 = 'ICDEVN'
    12. 

  12. 						, C_16 = 'TRANSACTION_CODE', P_16 = 'dspTransactionCode'
    13. 

  13. 						, C_17 = 'DATE_TIME', P_17 = 'TLBTDT'
    14. 

  14. 						, C_19 = 'REVERSAL_INDICATOR', P_19 = 'TLBWC2' WHERE TYPE = 'dsp-abcs-request';
    15. 

  15. 

  16. INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
    17. 

  17. 	VALUES ('dsp-abcs-response', 'dsp-response', NULL, CURRENT USER, CURRENT TIMESTAMP);
    18. 

  18. UPDATE MWLOG.DLOG_MD SET C_11 = 'SEQUENCE_NUMBER', P_11 = 'sequenceNumber'
    19. 

  19. 						, C_12 = 'TELLER_ID', P_12 = 'dspUserId'
    20. 

  20. 						, C_13 = 'WORKSTATION_ID', P_13 = 'dspTerminalId'
    21. 

  21. 						, C_15 = 'IP_ADDRESS', P_15 = 'ICDEVN'
    22. 

  22. 						, C_16 = 'TRANSACTION_CODE', P_16 = 'dspTransactionCode'
    23. 

  23. 						, C_17 = 'ABCS_RESPONSES', P_17 = 'abcsResponses'
    24. 

  24. 						, C_18 = 'RESPONSE_CODE', P_18 = 'responseCode'
    25. 

  25. 						, C_19 = 'ERROR_DESC', P_19 = 'ERROR_F2' WHERE TYPE = 'dsp-abcs-response';
    26. 

  26. 

  27. INSERT INTO MWLOG.DLOG_MD (TYPE, PBASE, MODIFIED_BY, TIMESTAMP, C_1, P_1, C_2, P_2, C_3, P_3)
    28. 

  28. 	VALUES ('error', '.', CURRENT USER, CURRENT TIMESTAMP, 'TELLER_ID', 'data/body/dspUserId', 'WORKSTATION_ID', 'data/body/dspTerminalId','SEQUENCE_NUMBER', 'data/body/sequenceNumber');
    29. 

  29. 

  30. INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
    31. 

  31. 	VALUES ('iso-8583-itm', 'iso-8583-itm', NULL, CURRENT USER, CURRENT TIMESTAMP);
    32. 

  32. UPDATE MWLOG.DLOG_MD SET 
    33. 

  33. 						  C_1 = 'systemsTraceAuditNumber', P_1 = 'systemsTraceAuditNumber'
    34. 

  34. 						, C_2 = 'transmissionDateTime', P_2 = 'transmissionDateTime'
    35. 

  35. 						, C_3 = 'merchantType', P_3 = 'merchantType'
    36. 

  36. 						, C_4 = 'responseCode', P_4 = 'responseCode'
    37. 

  37. 						, C_5 = 'cardAcceptorTerminalIdentification', P_5 = 'cardAcceptorTerminalIdentification'
    38. 

  38. 						, C_6 = 'cardAcceptorName', P_6 = 'cardAcceptorName'
    39. 

  39. 						, C_7 = 'primaryAccountNumber', P_7 = 'primaryAccountNumber'
    40. 

  40. 						, C_8 = 'fromAccount', P_8 = 'fromAccount'
    41. 

  41. 						, C_9 = 'toAccount', P_9 = 'toAccount'
    42. 

  42. 						, C_10 = 'amountTransaction', P_10 = 'amountTransaction'
    43. 

  43. 						, C_11 = 'dateSettlement', P_11 = 'dateSettlement'
    44. 

  44. 						, C_12 = 'retrievalReferenceNumber', P_12 = 'retrievalReferenceNumber'
    45. 

  45. 						, C_13 = 'dateLocalTransaction', P_13 = 'dateLocalTransaction'
    46. 

  46. 						, C_14 = 'timeLocalTransaction', P_14 = 'timeLocalTransaction'
    47. 

  47. 						, C_15 = 'dateCapture', P_15 = 'dateCapture'
    48. 

  48. 						, C_16 = 'track2data', P_16 = 'track2data'
    49. 

  49. 						, C_17 = 'acquiringInstitutionIdentificationCode', P_17 = 'acquiringInstitutionIdentificationCode'
    50. 

  50. 						, C_21 = 'reservedPrivate3', P_21 = 'reservedPrivate3'
    51. 

  51. 						, C_39 = 'additionalDataPrivate', P_39 = 'additionalDataPrivate'
    52. 

  52. 						, C_40 = 'reservedPrivate2', P_40 = 'reservedPrivate2'
    53. 

  53. 						, MODIFIED_BY = CURRENT USER
    54. 

  54. 						, TIMESTAMP = CURRENT TIMESTAMP WHERE TYPE = 'iso-8583-itm';
    55. 

  55. 

  56. INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
    57. 

  57. 	VALUES ('iso-8583-sms', 'iso-8583-sms', NULL, CURRENT USER, CURRENT TIMESTAMP);
    58. 

  58. UPDATE MWLOG.DLOG_MD SET 
    59. 

  59. 						  C_1 = 'systemsTraceAuditNumber', P_1 = 'systemsTraceAuditNumber'
    60. 

  60. 						, C_2 = 'transmissionDateTime', P_2 = 'transmissionDateTime'
    61. 

  61. 						, C_3 = 'merchantType', P_3 = 'merchantType'
    62. 

  62. 						, C_4 = 'responseCode', P_4 = 'responseCode'
    63. 

  63. 						, C_5 = 'cardAcceptorTerminalIdentification', P_5 = 'cardAcceptorTerminalIdentification'
    64. 

  64. 						, C_6 = 'cardAcceptorName', P_6 = 'cardAcceptorName'
    65. 

  65. 						, C_7 = 'primaryAccountNumber', P_7 = 'primaryAccountNumber'
    66. 

  66. 						, C_8 = 'fromAccount', P_8 = 'fromAccount'
    67. 

  67. 						, C_9 = 'toAccount', P_9 = 'toAccount'
    68. 

  68. 						, C_10 = 'amountTransaction', P_10 = 'amountTransaction'
    69. 

  69. 						, C_11 = 'dateSettlement', P_11 = 'dateSettlement'
    70. 

  70. 						, C_12 = 'retrievalReferenceNumber', P_12 = 'retrievalReferenceNumber'
    71. 

  71. 						, C_13 = 'dateLocalTransaction', P_13 = 'dateLocalTransaction'
    72. 

  72. 						, C_14 = 'timeLocalTransaction', P_14 = 'timeLocalTransaction'
    73. 

  73. 						, C_15 = 'dateCapture', P_15 = 'dateCapture'
    74. 

  74. 						, C_16 = 'track2data', P_16 = 'track2data'
    75. 

  75. 						, C_17 = 'acquiringInstitutionIdentificationCode', P_17 = 'acquiringInstitutionIdentificationCode'
    76. 

  76. 						, C_21 = 'reservedPrivate3', P_21 = 'reservedPrivate3'
    77. 

  77. 						, C_39 = 'additionalDataPrivate', P_39 = 'additionalDataPrivate'
    78. 

  78. 						, C_40 = 'reservedPrivate2', P_40 = 'reservedPrivate2'
    79. 

  79. 						, MODIFIED_BY = CURRENT USER
    80. 

  80. 						, TIMESTAMP = CURRENT TIMESTAMP WHERE TYPE = 'iso-8583-sms';
    81. 

  81. 

  82. INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
    83. 

  83. 	VALUES ('iso-8583-itmibft', 'iso-8583-itmibft', NULL, CURRENT USER, CURRENT TIMESTAMP);
    84. 

  84. UPDATE MWLOG.DLOG_MD SET 
    85. 

  85. 						  C_1 = 'systemsTraceAuditNumber', P_1 = 'systemsTraceAuditNumber'
    86. 

  86. 						, C_2 = 'transmissionDateTime', P_2 = 'transmissionDateTime'
    87. 

  87. 						, C_3 = 'merchantType', P_3 = 'merchantType'
    88. 

  88. 						, C_4 = 'responseCode', P_4 = 'responseCode'
    89. 

  89. 						, C_5 = 'cardAcceptorTerminalIdentification', P_5 = 'cardAcceptorTerminalIdentification'
    90. 

  90. 						, C_6 = 'cardAcceptorName', P_6 = 'cardAcceptorName'
    91. 

  91. 						, C_7 = 'primaryAccountNumber', P_7 = 'primaryAccountNumber'
    92. 

  92. 						, C_8 = 'fromAccount', P_8 = 'fromAccount'
    93. 

  93. 						, C_9 = 'toAccount', P_9 = 'toAccount'
    94. 

  94. 						, C_10 = 'amountTransaction', P_10 = 'amountTransaction'
    95. 

  95. 						, C_11 = 'dateSettlement', P_11 = 'dateSettlement'
    96. 

  96. 						, C_12 = 'retrievalReferenceNumber', P_12 = 'retrievalReferenceNumber'
    97. 

  97. 						, C_13 = 'dateLocalTransaction', P_13 = 'dateLocalTransaction'
    98. 

  98. 						, C_14 = 'timeLocalTransaction', P_14 = 'timeLocalTransaction'
    99. 

  99. 						, C_15 = 'dateCapture', P_15 = 'dateCapture'
    100. 

  100. 						, C_16 = 'track2data', P_16 = 'track2data'
    101. 

  101. 						, C_17 = 'acquiringInstitutionIdentificationCode', P_17 = 'acquiringInstitutionIdentificationCode'
    102. 

  102. 						, C_21 = 'reservedPrivate3', P_21 = 'reservedPrivate3'
    103. 

  103. 						, C_39 = 'additionalDataPrivate', P_39 = 'additionalDataPrivate'
    104. 

  104. 						, C_40 = 'reservedPrivate2', P_40 = 'reservedPrivate2'
    105. 

  105. 						, MODIFIED_BY = CURRENT USER
    106. 

  106. 						, TIMESTAMP = CURRENT TIMESTAMP WHERE TYPE = 'iso-8583-itmibft';
    107. 

  107. 

  108. INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
    109. 

  109. 	VALUES ('iso-8583-cms', 'iso-8583-cms', NULL, CURRENT USER, CURRENT TIMESTAMP);
    110. 

  110. UPDATE MWLOG.DLOG_MD SET 
    111. 

  111. 						  C_1 = 'systemsTraceAuditNumber', P_1 = 'systemsTraceAuditNumber'
    112. 

  112. 						, C_2 = 'transmissionDateTime', P_2 = 'transmissionDateTime'
    113. 

  113. 						, C_3 = 'merchantType', P_3 = 'merchantType'
    114. 

  114. 						, C_4 = 'responseCode', P_4 = 'responseCode'
    115. 

  115. 						, C_5 = 'cardAcceptorTerminalIdentification', P_5 = 'cardAcceptorTerminalIdentification'
    116. 

  116. 						, C_6 = 'cardAcceptorName', P_6 = 'cardAcceptorName'
    117. 

  117. 						, C_7 = 'primaryAccountNumber', P_7 = 'primaryAccountNumber'
    118. 

  118. 						, C_8 = 'fromAccount', P_8 = 'fromAccount'
    119. 

  119. 						, C_9 = 'toAccount', P_9 = 'toAccount'
    120. 

  120. 						, C_10 = 'amountTransaction', P_10 = 'amountTransaction'
    121. 

  121. 						, C_11 = 'dateSettlement', P_11 = 'dateSettlement'
    122. 

  122. 						, C_12 = 'retrievalReferenceNumber', P_12 = 'retrievalReferenceNumber'
    123. 

  123. 						, C_13 = 'dateLocalTransaction', P_13 = 'dateLocalTransaction'
    124. 

  124. 						, C_14 = 'timeLocalTransaction', P_14 = 'timeLocalTransaction'
    125. 

  125. 						, C_15 = 'dateCapture', P_15 = 'dateCapture'
    126. 

  126. 						, C_16 = 'track2data', P_16 = 'track2data'
    127. 

  127. 						, C_17 = 'acquiringInstitutionIdentificationCode', P_17 = 'acquiringInstitutionIdentificationCode'
    128. 

  128. 						, C_21 = 'reservedPrivate3', P_21 = 'reservedPrivate3'
    129. 

  129. 						, C_39 = 'additionalDataPrivate', P_39 = 'additionalDataPrivate'
    130. 

  130. 						, C_40 = 'reservedPrivate2', P_40 = 'reservedPrivate2'
    131. 

  131. 						, MODIFIED_BY = CURRENT USER
    132. 

  132. 						, TIMESTAMP = CURRENT TIMESTAMP WHERE TYPE = 'iso-8583-cms';
    133. 

  133. 

  134. INSERT INTO MWLOG.DLOG_MD (TYPE,PCORRELATIONID,PSOURCE,PCODE,PBASE,MODIFIED_BY,TIMESTAMP,C_1,P_1,C_2,P_2,C_3,P_3,C_4,P_4,C_5,P_5,C_6,P_6,C_7,P_7,C_8,P_8,C_9,P_9,C_10,P_10,C_11,P_11,C_12,P_12,C_13,P_13,C_14,P_14,C_15,P_15,C_16,P_16,C_17,P_17,C_18,P_18,C_19,P_19,C_20,P_20,C_21,P_21,C_22,P_22,C_23,P_23,C_24,P_24,C_25,P_25,C_26,P_26,C_27,P_27,C_28,P_28,C_29,P_29,C_30,P_30,C_31,P_31,C_32,P_32,C_33,P_33,C_34,P_34,C_35,P_35,C_36,P_36,C_37,P_37,C_38,P_38,C_39,P_39,C_40,P_40,CODEX) VALUES
    135. 

  135. 	 ('http://*',NULL,NULL,NULL,'.',CURRENT USER,CURRENT TIMESTAMP,'X-Remote-Addr','/HTTPInputHeader/X-Remote-Addr','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'http://*');
    136. 

  136. 

  137. 

  138. INSERT INTO MWLOG.DLOG_MD (TYPE,PCORRELATIONID,PSOURCE,PCODE,PBASE,MODIFIED_BY,TIMESTAMP,C_1,P_1,C_2,P_2,C_3,P_3,C_4,P_4,C_5,P_5,C_6,P_6,C_7,P_7,C_8,P_8,C_9,P_9,C_10,P_10,C_11,P_11,C_12,P_12,C_13,P_13,C_14,P_14,C_15,P_15,C_16,P_16,C_17,P_17,C_18,P_18,C_19,P_19,C_20,P_20,C_21,P_21,C_22,P_22,C_23,P_23,C_24,P_24,C_25,P_25,C_26,P_26,C_27,P_27,C_28,P_28,C_29,P_29,C_30,P_30,C_31,P_31,C_32,P_32,C_33,P_33,C_34,P_34,C_35,P_35,C_36,P_36,C_37,P_37,C_38,P_38,C_39,P_39,C_40,P_40,CODEX) VALUES
    139. 

  139. 	 ('http://NonMonetary/*',NULL,NULL,NULL,'.',CURRENT USER,CURRENT TIMESTAMP,'X-Remote-Addr','/HTTPInputHeader/X-Remote-Addr','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'http://*');
    140. 

  140. 

  141. 

  142. INSERT INTO MWLOG.DLOG_MD (TYPE,PCORRELATIONID,PSOURCE,PCODE,PBASE,MODIFIED_BY,TIMESTAMP,C_1,P_1,C_2,P_2,C_3,P_3,C_4,P_4,C_5,P_5,C_6,P_6,C_7,P_7,C_8,P_8,C_9,P_9,C_10,P_10,C_11,P_11,C_12,P_12,C_13,P_13,C_14,P_14,C_15,P_15,C_16,P_16,C_17,P_17,C_18,P_18,C_19,P_19,C_20,P_20,C_21,P_21,C_22,P_22,C_23,P_23,C_24,P_24,C_25,P_25,C_26,P_26,C_27,P_27,C_28,P_28,C_29,P_29,C_30,P_30,C_31,P_31,C_32,P_32,C_33,P_33,C_34,P_34,C_35,P_35,C_36,P_36,C_37,P_37,C_38,P_38,C_39,P_39,C_40,P_40,CODEX) VALUES
    143. 

  143. 	 ('http://Monetary/*',NULL,NULL,NULL,'.',CURRENT USER,CURRENT TIMESTAMP,'X-Remote-Addr','/HTTPInputHeader/X-Remote-Addr','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'http://*');
    144. 

  144. 

  145. INSERT INTO MWLOG.DLOG_MD (TYPE,PCORRELATIONID,PSOURCE,PCODE,PBASE,MODIFIED_BY,TIMESTAMP,C_1,P_1,C_2,P_2,C_3,P_3,C_4,P_4,C_5,P_5,C_6,P_6,C_7,P_7,C_8,P_8,C_9,P_9,C_10,P_10,C_11,P_11,C_12,P_12,C_13,P_13,C_14,P_14,C_15,P_15,C_16,P_16,C_17,P_17,C_18,P_18,C_19,P_19,C_20,P_20,C_21,P_21,C_22,P_22,C_23,P_23,C_24,P_24,C_25,P_25,C_26,P_26,C_27,P_27,C_28,P_28,C_29,P_29,C_30,P_30,C_31,P_31,C_32,P_32,C_33,P_33,C_34,P_34,C_35,P_35,C_36,P_36,C_37,P_37,C_38,P_38,C_39,P_39,C_40,P_40,CODEX) VALUES
    146. 

  146. 	 ('http://CoreRpg/*',NULL,NULL,NULL,'.',CURRENT USER,CURRENT TIMESTAMP,'X-Remote-Addr','/HTTPInputHeader/X-Remote-Addr','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'http://*');
    147. 

  147. 

  148. UPDATE MWLOG.DLOG_MD
    149. 

  149. SET PCORRELATIONID=NULL, PSOURCE=NULL, PCODE=NULL, PBASE='.', MODIFIED_BY='DEPLOY  ', "TIMESTAMP"='2025-01-09 11:26:31.622387', C_1=NULL, P_1=NULL, C_2=NULL, P_2=NULL, C_3=NULL, P_3=NULL, C_4=NULL, P_4=NULL, C_5=NULL, P_5=NULL, C_6=NULL, P_6=NULL, C_7=NULL, P_7=NULL, C_8=NULL, P_8=NULL, C_9=NULL, P_9=NULL, C_10=NULL, P_10=NULL, C_11='X-Remote-Addr', P_11='/SOAP/Header/X-Remote-Addr', C_12='referenceNumber', P_12='/SOAP/Body/*/Data/referenceNumber', C_13='tellerId', P_13='/SOAP/Body/*/Data/tellerId', C_14='journalSequence', P_14='/SOAP/Body/*/Data/journalSequence', C_15='field1', P_15='/SOAP/Body/*/Data/field1', C_16='field15', P_16='/SOAP/Body/*/Data/field15', C_17='transactionCode', P_17='/SOAP/Body/*/Data/transactionCode', C_18='responseCode', P_18='/SOAP/Body/*/Data/responseCode', C_19=NULL, P_19=NULL, C_20=NULL, P_20=NULL, C_21=NULL, P_21=NULL, C_22=NULL, P_22=NULL, C_23=NULL, P_23=NULL, C_24=NULL, P_24=NULL, C_25=NULL, P_25=NULL, C_26=NULL, P_26=NULL, C_27=NULL, P_27=NULL, C_28=NULL, P_28=NULL, C_29=NULL, P_29=NULL, C_30=NULL, P_30=NULL, C_31=NULL, P_31=NULL, C_32=NULL, P_32=NULL, C_33=NULL, P_33=NULL, C_34=NULL, P_34=NULL, C_35=NULL, P_35=NULL, C_36=NULL, P_36=NULL, C_37=NULL, P_37=NULL, C_38=NULL, P_38=NULL, C_39=NULL, P_39=NULL, C_40=NULL, P_40=NULL, CODEX='http://*'
    150. 

  150. WHERE "TYPE"='http://Monetary/*';
    151. 

  151. UPDATE MWLOG.DLOG_MD
    152. 

  152. SET PCORRELATIONID=NULL, PSOURCE=NULL, PCODE=NULL, PBASE='.', MODIFIED_BY='DEPLOY  ', "TIMESTAMP"='2025-01-09 11:26:31.627974', C_1=NULL, P_1=NULL, C_2=NULL, P_2=NULL, C_3=NULL, P_3=NULL, C_4=NULL, P_4=NULL, C_5=NULL, P_5=NULL, C_6=NULL, P_6=NULL, C_7=NULL, P_7=NULL, C_8=NULL, P_8=NULL, C_9=NULL, P_9=NULL, C_10=NULL, P_10=NULL, C_11='X-Remote-Addr', P_11='/SOAP/Header/X-Remote-Addr', C_12='referenceNumber', P_12='/SOAP/Header/Btn-Reference-Number', C_13='userId', P_13='/SOAP/Header/Btn-User-Id', C_14=NULL, P_14=NULL, C_15=NULL, P_15=NULL, C_16=NULL, P_16=NULL, C_17=NULL, P_17=NULL, C_18='responseCode', P_18='/SOAP/Body/*/Data/responseCode', C_19=NULL, P_19=NULL, C_20=NULL, P_20=NULL, C_21=NULL, P_21=NULL, C_22=NULL, P_22=NULL, C_23=NULL, P_23=NULL, C_24=NULL, P_24=NULL, C_25=NULL, P_25=NULL, C_26=NULL, P_26=NULL, C_27=NULL, P_27=NULL, C_28=NULL, P_28=NULL, C_29=NULL, P_29=NULL, C_30=NULL, P_30=NULL, C_31=NULL, P_31=NULL, C_32=NULL, P_32=NULL, C_33=NULL, P_33=NULL, C_34=NULL, P_34=NULL, C_35=NULL, P_35=NULL, C_36=NULL, P_36=NULL, C_37=NULL, P_37=NULL, C_38=NULL, P_38=NULL, C_39=NULL, P_39=NULL, C_40=NULL, P_40=NULL, CODEX='http://*'
    153. 

  153. WHERE "TYPE"='http://NonMonetary/*';
    154. 

  154. UPDATE MWLOG.DLOG_MD
    155. 

  155. SET CODEX='http://*', PCORRELATIONID=NULL, PSOURCE=NULL, PCODE=NULL, PBASE='.', MODIFIED_BY='DB2INST1', "TIMESTAMP"='2026-05-04 07:55:37.386100', C_1='X-Remote-Addr', P_1='/HTTPInputHeader/X-Remote-Addr', C_2='', P_2='', C_3=NULL, P_3=NULL, C_4=NULL, P_4=NULL, C_5=NULL, P_5=NULL, C_6=NULL, P_6=NULL, C_7=NULL, P_7=NULL, C_8=NULL, P_8=NULL, C_9=NULL, P_9=NULL, C_10=NULL, P_10=NULL, C_11='COMMAND', P_11='/SOAP/Body/*/Data/Command', C_12='KEY', P_12='/SOAP/Body/*/Data/key', C_13=NULL, P_13=NULL, C_14=NULL, P_14=NULL, C_15=NULL, P_15=NULL, C_16=NULL, P_16=NULL, C_17=NULL, P_17=NULL, C_18=NULL, P_18=NULL, C_19=NULL, P_19=NULL, C_20=NULL, P_20=NULL, C_21=NULL, P_21=NULL, C_22=NULL, P_22=NULL, C_23=NULL, P_23=NULL, C_24=NULL, P_24=NULL, C_25=NULL, P_25=NULL, C_26=NULL, P_26=NULL, C_27=NULL, P_27=NULL, C_28=NULL, P_28=NULL, C_29=NULL, P_29=NULL, C_30=NULL, P_30=NULL, C_31=NULL, P_31=NULL, C_32=NULL, P_32=NULL, C_33=NULL, P_33=NULL, C_34=NULL, P_34=NULL, C_35=NULL, P_35=NULL, C_36=NULL, P_36=NULL, C_37=NULL, P_37=NULL, C_38=NULL, P_38=NULL, C_39=NULL, P_39=NULL, C_40=NULL, P_40=NULL
    156. 

  156. WHERE "TYPE"='http://CoreRpg/*';
    157.