| Author |
Message
|
| wmc27 |
 Posted: Thu Jun 20, 2013 7:34 pm Post subject: How to fix the DFDL schema |
 |
|
Apprentice
Joined: 18 Dec 2008
Posts: 31
|
My environment WMB 8.0.0.2
I am converting XML to flat file,
i am constructing the flat file in ESQL
SET OutputRoot.DFDL.xxx.xxxxx.field1=COALESCE(inRef.FIELD1,' ');
SET OutputRoot.DFDL.xxx.xxxxx.field2=COALESCE(inRef.FIEL1,' ');
etc....
Generated output is
04500870AAAAAAAA HD 00000000
00068090 BBBBBBBB CD 00000000
00007800 CCCCCCC KJ 00000000
etc..
But somehow 04500870 are generating/added before each record when the messages are propagating to MQOutput Node
i know it has something to do with the DFDL schema,Coz i am NOT writing any ESQL to generate these(04500870/00068090/00007800)
How to fix the DFDL schema to avoid any numbers before each record. |
|
| Back to top |
|
 |
| kash3338 |
| Posted: Thu Jun 20, 2013 7:39 pm Post subject: Re: How to fix the DFDL schema |
|
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
| wmc27 wrote: |
| How to fix the DFDL schema to avoid any numbers before each record. |
What is your FIELD1 in input XML? What is your field1 in your DFDL schema? |
|
| Back to top |
|
|
| wmc27 |
| Posted: Thu Jun 20, 2013 7:53 pm Post subject: |
|
|
Apprentice
Joined: 18 Dec 2008
Posts: 31
|
FIELD1 in input XML is SCP
field1 in your DFDL schema is QTY
i assume it is something to do with the DFDL Schema root tag as the root tag length is 8 digits
and 04500870 is 8 digits too... |
|
| Back to top |
|
|
| kimbert |
| Posted: Fri Jun 21, 2013 3:33 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
Er, two questions:
1. How do you expect us to answer your question when you have not supplied *any* details about the DFDL schema that you are using?
2. Have you looked at the DFDL Trace emitted by the serializer?
Please answer both questions. |
|
| Back to top |
|
|
| wmc27 |
| Posted: Fri Jun 21, 2013 5:38 am Post subject: |
|
|
Apprentice
Joined: 18 Dec 2008
Posts: 31
|
kimbert,
Problem solved,
Its not an issue with the DFDL schema.RFHUtil has generated that information,
Thx all for you time. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jun 21, 2013 7:16 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| wmc27 wrote: |
kimbert,
Problem solved,
Its not an issue with the DFDL schema.RFHUtil has generated that information,
Thx all for you time. |
So what you're saying is, you completely failed to understand that RFHUtil showed you two separate views of the message data, one in hex and one in "characters".
 |
|
| Back to top |
|
|
|
|
