MQSeries.net :: View topic

shalabh1976 · Posted: Fri May 27, 2005 3:15 am Post subject:

Here is my sample data:

C;000002;2005-MAY-17;2005-APR-17;SONY;SONY;JKL;1;000001;2;www.sony.com;CNAE;001;;;VGOMEZ;NIF;A;JKL;FGM;;;A;ESP;;1500;2005-MAY-17;20;DFLT;Y
A;000002;1;MAIN ADDRESS;2005-MAY-17;00189;CORSEGA 372;plazos de pago y cuenta;;;BARCELONA;CL;BARCELONA;08008;VGOMEZ
V;000002;1;2005-MAY-18;ESP;;VAT_APPLICABLE;T
V;000002;1;2005-MAY-18;ESP;;VAT_DCLRTN_PT_GDS;I
V;000002;1;2005-MAY-18;ESP;;VAT_DCLRTN_PT_SVC;I
V;000002;1;2005-MAY-18;ESP;TGS;TAX_CD_VAT;IV_STD
V;000002;1;2005-MAY-18;ESP;TSS;TAX_CD_VAT;IV_STD
A;000002;2;LOCAL ADDRESS;2005-MAY-17;00189;DIAGONAL 10;plazos de pago y cuenta;;;BARCELONA;CL;BARCELONA;08021;VGOMEZ
V;000002;2;2005-MAY-18;ESP;;VAT_APPLICABLE;T
V;000002;2;2005-MAY-18;ESP;;VAT_DCLRTN_PT_GDS;I
V;000002;2;2005-MAY-18;ESP;;VAT_DCLRTN_PT_SVC;I
V;000002;2;2005-MAY-18;ESP;TGS;TAX_CD_VAT;IV_STD
V;000002;2;2005-MAY-18;ESP;TSS;TAX_CD_VAT;IV_STD
C;000001;2005-MAY-17;2005-APR-17;FORD;FORD;JKL;1;000001;2;www.ford.com;CNAE;;;;OMN;NIF;A;JKL;FGM;;;A;ESP;;1500;2005-MAY-17;20;DFLT;Y
A;000001;1;MAIN ADD CUST 1;2005-MAY-19;00187;SARRIA 51;plazos de pago y cuenta;;;BARCELONA;CL;BARCELONA;08040;VGOMEZ
V;000001;1;2005-MAY-18;ESP;;VAT_APPLICABLE;T
V;000001;1;2005-MAY-18;ESP;;VAT_DCLRTN_PT_GDS;I
V;000001;1;2005-MAY-18;ESP;;VAT_DCLRTN_PT_SVC;I
V;000001;1;2005-MAY-18;ESP;TGS;TAX_CD_VAT;IG_STD

There will always be a Customer line, followed by an address line (if the address is new or has changed) and then VAT files related to the customer and address. Customer and VAT lines are optional and can repeat any number of times for a customer.

I was unable to use a MRM because each line format is dependant on the value in the first field ie C,V or A.

What I tried to do was to read in the message as a TDS where each line is delimited by CRLF. Now I substring for 1 from 1 to get the value of the first column and populate three arrays( 1 each for customer, address and Vat). Now I propagate the message and map the arrays to separate MRM's
and it works fine till here. Going ahead I think that I will need to aggregate the output and then do some manipulation to convert the message to XML.

I think it would have been better if the input could somehow have been mapped in the input itself rather than following this round about way.
Any suggestions to create a proper MRM that can read this message directly would be highly welcome.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate