| Author |
Message
|
| EricCox |
 Posted: Tue May 28, 2013 11:54 am Post subject: Message Broker 8 Fixed Length Message Model |
 |
|
Master
Joined: 08 Apr 2011
Posts: 292
|
To all,
Is there a document that gives an instruction on how to build a fixed length (characters) message model to use in a map?
I've tried to reach the gustafson article but the links in it aren't working.
I have a spreadsheet set up like this:
Name | Length | Position
FIELD1 | 5 |1-5
FIELD2 | 4 |6-9
FIELD2 | 4 |10-13
I'd like to use a wizard to interogate the spreadsheet, or any format, to build the Message Model. I've learned that creating these models from scratch is problematic.
If this spreadsheet isn't the right format let me know how to build it correctly and or point me to a doc that shows how. I'm familiar with Copybook to MRM but not the fixed length without copybook.
I tried to look at Redbooks but there are 700 or something. Is there one that has this?
Thanks,
EC |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue May 28, 2013 1:00 pm Post subject: Re: Message Broker 8 Fixed Length Message Model |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| EricCox wrote: |
| I'd like to use a wizard to interogate the spreadsheet, or any format, to build the Message Model. |
WMB v8 has one of those. WMB v7 does not.
| EricCox wrote: |
| I've learned that creating these models from scratch is problematic. |
"Problematic" is a bit harsh.
| EricCox wrote: |
| If this spreadsheet isn't the right format let me know |
There are no wrong formats. The data is the data.
All you're describing is 3 fields all of them fixed length I would have thought this would about cover it. Or you could mug up a copybook with 3 PIC X( n) fields of the right length and import that to make a model.
Am I missing something? Not impossible, long day here.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| EricCox |
| Posted: Wed May 29, 2013 7:26 am Post subject: DFDL Schema |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
I hear ya.
I think I'll try to build a DFDL Schema to support the transform.
My question was targeted at a kind of plain text copybook which can then be read in by a wizard and create the DFDL Schema similar to the way Copybook works.
It sounds like crafting the DFDL from hand is easiest?
Thanks |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed May 29, 2013 7:36 am Post subject: Re: DFDL Schema |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| EricCox wrote: |
| My question was targeted at a kind of plain text copybook which can then be read in by a wizard and create the DFDL Schema similar to the way Copybook works. |
Doesn't the WMBv8 Tooling have this? I know you can test your schema to see if it matches some test data, can't you mark up the test data into a schema?
| EricCox wrote: |
| It sounds like crafting the DFDL from hand is easiest? |
For something of the complexity you're describing I'd say yes. Or express it as a copybook and import that. 6 to one, half dozen of the other as my mum would say...
Note also my last link was to WMBv7 not v8. Sorry. Try this for record orientated.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| EricCox |
| Posted: Wed May 29, 2013 7:41 am Post subject: Test Data |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
Unfortunately I don't have valid test data. All I have is the spreadsheet with the field layouts. I was hoping to use something like that as you do with COBOL copybook. But I haven't found an instruction on how to build something similar to use in the wizard.
So I'm left crafting the DFDL Schema by hand. It's ok but it's 118 fields. I was hoping to find a tool/wizard to help me use a field layout.txt file or something as we do with the copybook.
Thanks,
EC |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed May 29, 2013 10:30 am Post subject: Re: Test Data |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| EricCox wrote: |
| Unfortunately I don't have valid test data. |
now there's a surprise 
This isn't all that uncommon. In these cases, I reverse the process.
By this I mean, I generate a message tree and get the parser to create the output message for me. I can iterate the development until I get the complete message model developed.
You just have to take a deep breathe, give out a big sigh and bite the bullet.
If you don't have a valid xsd/Copybook then there is not much else you can do.
I'd really like to know if there is a better way but I don't think so.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| EricCox |
| Posted: Wed May 29, 2013 10:36 am Post subject: Bitten |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
You said
| Quote: |
You just have to take a deep breathe, give out a big sigh and bite the bullet.
If you don't have a valid xsd/Copybook then there is not much else you can do.
|
Here is where vision, perspective, time, experience, patience and the ability to adapt and overcome are the skills and tools of champions.
I've been biting on the proverbial bullet.
I love a new challenge.
Once I get the model working correctly I'll be golden for a whole bunch of other great progress.
Thanks for your perspective. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed May 29, 2013 11:39 am Post subject: Re: Bitten |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| EricCox wrote: |
| Here is where vision, perspective, time, experience, patience and the ability to adapt and overcome are the skills and tools of champions. |
All of them? 
I should give the award back.... 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| EricCox |
| Posted: Wed May 29, 2013 11:41 am Post subject: Award? |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
Well one should qualify but those and more are required for the job.
Hey....where is my award? LOL |
|
| Back to top |
|
|
| kimbert |
| Posted: Mon Jun 10, 2013 3:41 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
My question was targeted at a kind of plain text copybook which can then be read in by a wizard and create the DFDL Schema similar to the way Copybook works.
It sounds like crafting the DFDL from hand is easiest? |
There is a third possibility. DFDL is an open standard, so you can safely generate DFDL xsds from your spreadsheet using a script or program. That would be my recommendation. It's safer and less boring than doing it all by hand. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Jun 10, 2013 6:25 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Depending on how fluent you are in COBOL, you could use the spreadsheet to create a copy book and ingest that in DFDL... although I'd probably just ask the originating team for the copybook... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| EricCox |
| Posted: Mon Jun 10, 2013 7:27 am Post subject: 3rd Party Vendor |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
Hi FJ,
I hope all is well. This is from a 3rd party vendor. All they gave us is a spreadsheet as described here.
I went ahead and hand crafted the DFDL Schema.
I'm in the process of trying to run the transformation and use the new DFDL.
Thanks,
Eric |
|
| Back to top |
|
|
|
|
