yusuf
/
btnmw-server-local
ответвлено от wisnu/btnmw-server-local


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156
							INSERT INTO MWLOG.DLOG_MD (TYPE, PBASE, MODIFIED_BY, TIMESTAMP)
	VALUES ('*', '.', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
	VALUES ('dsp-abcs-request', 'dsp', NULL, CURRENT USER, CURRENT TIMESTAMP);
UPDATE MWLOG.DLOG_MD SET CODEX = 'dsp'	
						, C_11 = 'SEQUENCE_NUMBER', P_11 = 'TLBJSN'
						, C_12 = 'TELLER_ID', P_12 = 'dspUserId'
						, C_13 = 'WORKSTATION_ID', P_13 = 'dspTerminalId'
						, C_14 = 'CONTROL_UNIT', P_14 = 'TLBCUD'
						, C_15 = 'IP_ADDRESS', P_15 = 'ICDEVN'
						, C_16 = 'TRANSACTION_CODE', P_16 = 'dspTransactionCode'
						, C_17 = 'DATE_TIME', P_17 = 'TLBTDT'
						, C_19 = 'REVERSAL_INDICATOR', P_19 = 'TLBWC2' WHERE TYPE = 'dsp-abcs-request';

INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
	VALUES ('dsp-abcs-response', 'dsp-response', NULL, CURRENT USER, CURRENT TIMESTAMP);
UPDATE MWLOG.DLOG_MD SET C_11 = 'SEQUENCE_NUMBER', P_11 = 'sequenceNumber'
						, C_12 = 'TELLER_ID', P_12 = 'dspUserId'
						, C_13 = 'WORKSTATION_ID', P_13 = 'dspTerminalId'
						, C_15 = 'IP_ADDRESS', P_15 = 'ICDEVN'
						, C_16 = 'TRANSACTION_CODE', P_16 = 'dspTransactionCode'
						, C_17 = 'ABCS_RESPONSES', P_17 = 'abcsResponses'
						, C_18 = 'RESPONSE_CODE', P_18 = 'responseCode'
						, C_19 = 'ERROR_DESC', P_19 = 'ERROR_F2' WHERE TYPE = 'dsp-abcs-response';

INSERT INTO MWLOG.DLOG_MD (TYPE, PBASE, MODIFIED_BY, TIMESTAMP, C_1, P_1, C_2, P_2, C_3, P_3)
	VALUES ('error', '.', CURRENT USER, CURRENT TIMESTAMP, 'TELLER_ID', 'data/body/dspUserId', 'WORKSTATION_ID', 'data/body/dspTerminalId','SEQUENCE_NUMBER', 'data/body/sequenceNumber');

INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
	VALUES ('iso-8583-itm', 'iso-8583-itm', NULL, CURRENT USER, CURRENT TIMESTAMP);
UPDATE MWLOG.DLOG_MD SET 
						  C_1 = 'systemsTraceAuditNumber', P_1 = 'systemsTraceAuditNumber'
						, C_2 = 'transmissionDateTime', P_2 = 'transmissionDateTime'
						, C_3 = 'merchantType', P_3 = 'merchantType'
						, C_4 = 'responseCode', P_4 = 'responseCode'
						, C_5 = 'cardAcceptorTerminalIdentification', P_5 = 'cardAcceptorTerminalIdentification'
						, C_6 = 'cardAcceptorName', P_6 = 'cardAcceptorName'
						, C_7 = 'primaryAccountNumber', P_7 = 'primaryAccountNumber'
						, C_8 = 'fromAccount', P_8 = 'fromAccount'
						, C_9 = 'toAccount', P_9 = 'toAccount'
						, C_10 = 'amountTransaction', P_10 = 'amountTransaction'
						, C_11 = 'dateSettlement', P_11 = 'dateSettlement'
						, C_12 = 'retrievalReferenceNumber', P_12 = 'retrievalReferenceNumber'
						, C_13 = 'dateLocalTransaction', P_13 = 'dateLocalTransaction'
						, C_14 = 'timeLocalTransaction', P_14 = 'timeLocalTransaction'
						, C_15 = 'dateCapture', P_15 = 'dateCapture'
						, C_16 = 'track2data', P_16 = 'track2data'
						, C_17 = 'acquiringInstitutionIdentificationCode', P_17 = 'acquiringInstitutionIdentificationCode'
						, C_21 = 'reservedPrivate3', P_21 = 'reservedPrivate3'
						, C_39 = 'additionalDataPrivate', P_39 = 'additionalDataPrivate'
						, C_40 = 'reservedPrivate2', P_40 = 'reservedPrivate2'
						, MODIFIED_BY = CURRENT USER
						, TIMESTAMP = CURRENT TIMESTAMP WHERE TYPE = 'iso-8583-itm';

INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
	VALUES ('iso-8583-sms', 'iso-8583-sms', NULL, CURRENT USER, CURRENT TIMESTAMP);
UPDATE MWLOG.DLOG_MD SET 
						  C_1 = 'systemsTraceAuditNumber', P_1 = 'systemsTraceAuditNumber'
						, C_2 = 'transmissionDateTime', P_2 = 'transmissionDateTime'
						, C_3 = 'merchantType', P_3 = 'merchantType'
						, C_4 = 'responseCode', P_4 = 'responseCode'
						, C_5 = 'cardAcceptorTerminalIdentification', P_5 = 'cardAcceptorTerminalIdentification'
						, C_6 = 'cardAcceptorName', P_6 = 'cardAcceptorName'
						, C_7 = 'primaryAccountNumber', P_7 = 'primaryAccountNumber'
						, C_8 = 'fromAccount', P_8 = 'fromAccount'
						, C_9 = 'toAccount', P_9 = 'toAccount'
						, C_10 = 'amountTransaction', P_10 = 'amountTransaction'
						, C_11 = 'dateSettlement', P_11 = 'dateSettlement'
						, C_12 = 'retrievalReferenceNumber', P_12 = 'retrievalReferenceNumber'
						, C_13 = 'dateLocalTransaction', P_13 = 'dateLocalTransaction'
						, C_14 = 'timeLocalTransaction', P_14 = 'timeLocalTransaction'
						, C_15 = 'dateCapture', P_15 = 'dateCapture'
						, C_16 = 'track2data', P_16 = 'track2data'
						, C_17 = 'acquiringInstitutionIdentificationCode', P_17 = 'acquiringInstitutionIdentificationCode'
						, C_21 = 'reservedPrivate3', P_21 = 'reservedPrivate3'
						, C_39 = 'additionalDataPrivate', P_39 = 'additionalDataPrivate'
						, C_40 = 'reservedPrivate2', P_40 = 'reservedPrivate2'
						, MODIFIED_BY = CURRENT USER
						, TIMESTAMP = CURRENT TIMESTAMP WHERE TYPE = 'iso-8583-sms';

INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
	VALUES ('iso-8583-itmibft', 'iso-8583-itmibft', NULL, CURRENT USER, CURRENT TIMESTAMP);
UPDATE MWLOG.DLOG_MD SET 
						  C_1 = 'systemsTraceAuditNumber', P_1 = 'systemsTraceAuditNumber'
						, C_2 = 'transmissionDateTime', P_2 = 'transmissionDateTime'
						, C_3 = 'merchantType', P_3 = 'merchantType'
						, C_4 = 'responseCode', P_4 = 'responseCode'
						, C_5 = 'cardAcceptorTerminalIdentification', P_5 = 'cardAcceptorTerminalIdentification'
						, C_6 = 'cardAcceptorName', P_6 = 'cardAcceptorName'
						, C_7 = 'primaryAccountNumber', P_7 = 'primaryAccountNumber'
						, C_8 = 'fromAccount', P_8 = 'fromAccount'
						, C_9 = 'toAccount', P_9 = 'toAccount'
						, C_10 = 'amountTransaction', P_10 = 'amountTransaction'
						, C_11 = 'dateSettlement', P_11 = 'dateSettlement'
						, C_12 = 'retrievalReferenceNumber', P_12 = 'retrievalReferenceNumber'
						, C_13 = 'dateLocalTransaction', P_13 = 'dateLocalTransaction'
						, C_14 = 'timeLocalTransaction', P_14 = 'timeLocalTransaction'
						, C_15 = 'dateCapture', P_15 = 'dateCapture'
						, C_16 = 'track2data', P_16 = 'track2data'
						, C_17 = 'acquiringInstitutionIdentificationCode', P_17 = 'acquiringInstitutionIdentificationCode'
						, C_21 = 'reservedPrivate3', P_21 = 'reservedPrivate3'
						, C_39 = 'additionalDataPrivate', P_39 = 'additionalDataPrivate'
						, C_40 = 'reservedPrivate2', P_40 = 'reservedPrivate2'
						, MODIFIED_BY = CURRENT USER
						, TIMESTAMP = CURRENT TIMESTAMP WHERE TYPE = 'iso-8583-itmibft';

INSERT INTO MWLOG.DLOG_MD (TYPE, CODEX, PBASE, MODIFIED_BY, TIMESTAMP)
	VALUES ('iso-8583-cms', 'iso-8583-cms', NULL, CURRENT USER, CURRENT TIMESTAMP);
UPDATE MWLOG.DLOG_MD SET 
						  C_1 = 'systemsTraceAuditNumber', P_1 = 'systemsTraceAuditNumber'
						, C_2 = 'transmissionDateTime', P_2 = 'transmissionDateTime'
						, C_3 = 'merchantType', P_3 = 'merchantType'
						, C_4 = 'responseCode', P_4 = 'responseCode'
						, C_5 = 'cardAcceptorTerminalIdentification', P_5 = 'cardAcceptorTerminalIdentification'
						, C_6 = 'cardAcceptorName', P_6 = 'cardAcceptorName'
						, C_7 = 'primaryAccountNumber', P_7 = 'primaryAccountNumber'
						, C_8 = 'fromAccount', P_8 = 'fromAccount'
						, C_9 = 'toAccount', P_9 = 'toAccount'
						, C_10 = 'amountTransaction', P_10 = 'amountTransaction'
						, C_11 = 'dateSettlement', P_11 = 'dateSettlement'
						, C_12 = 'retrievalReferenceNumber', P_12 = 'retrievalReferenceNumber'
						, C_13 = 'dateLocalTransaction', P_13 = 'dateLocalTransaction'
						, C_14 = 'timeLocalTransaction', P_14 = 'timeLocalTransaction'
						, C_15 = 'dateCapture', P_15 = 'dateCapture'
						, C_16 = 'track2data', P_16 = 'track2data'
						, C_17 = 'acquiringInstitutionIdentificationCode', P_17 = 'acquiringInstitutionIdentificationCode'
						, C_21 = 'reservedPrivate3', P_21 = 'reservedPrivate3'
						, C_39 = 'additionalDataPrivate', P_39 = 'additionalDataPrivate'
						, C_40 = 'reservedPrivate2', P_40 = 'reservedPrivate2'
						, MODIFIED_BY = CURRENT USER
						, TIMESTAMP = CURRENT TIMESTAMP WHERE TYPE = 'iso-8583-cms';

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
	 ('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://*');


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
	 ('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://*');


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
	 ('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://*');

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
	 ('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://*');

UPDATE MWLOG.DLOG_MD
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://*'
WHERE "TYPE"='http://Monetary/*';
UPDATE MWLOG.DLOG_MD
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://*'
WHERE "TYPE"='http://NonMonetary/*';
UPDATE MWLOG.DLOG_MD
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
WHERE "TYPE"='http://CoreRpg/*';