| Author |
Message
|
| migstr |
 Posted: Wed Nov 13, 2002 11:42 am Post subject: Tagged/Delimited Help Please |
 |
|
Apprentice
Joined: 05 Jun 2002
Posts: 34
Location: New York
|
Hi,
Before I begin tearing my hair out on this one, can someone tell me if this is even possible using the TaggedDelimited messages.
I wil be receiving a message that is really an old legacy format that uses different record structures based on the 1st 8 characters of the structure, like this:
Message
HEADER01xxxxxx
DETA0001xxxxxxx
DETA0001xxxxxxx
DETB0001xxxx
DETC0001xxxxxx
DETD0001xxx
The xxxx structure data is both character and fixed decimal. Is this possible to do? Has anybody done this? Thanks in advance. |
|
| Back to top |
|
 |
| cute_pav |
| Posted: Wed Nov 13, 2002 12:07 pm Post subject: |
|
|
Acolyte
Joined: 04 Jan 2002
Posts: 65
Location: usa
|
Hi mig,
Is this is a single message different records from legacy to your box?
or
Is this a file which contains this type of messages and fed as each record is fed as single message to your box?
what you want to do once you recieve this kind of messages?
If at all all are fed as an individual messages, is that messages are of same length?
In nutshell, its possible to transform this kind of messages but you should aware of input message handling of such message to your side(WMQI).
feel free to explain.
pavan |
|
| Back to top |
|
|
| migstr |
| Posted: Wed Nov 13, 2002 12:24 pm Post subject: |
|
|
Apprentice
Joined: 05 Jun 2002
Posts: 34
Location: New York
|
Hi, Thanks for answering.
This is a single message with different records from legacy to my broker. It's actually an invoice with a header tag and many different detail tags. So I need to take this invoice and transform it into another MRM structure, an SAP IDOC. So I will need to reference different fields within each header and detail structure. There are amounts in it, which explains the need for fixed decimal. If I have to do the BLOB thing instead of using TAGGED/DELIMITED, I may opt to fiddle with the legacy format before I send it into WMQI. But before I pursue that, I'd like to see if I could use TAGGED/DELIMITED. I saw a write up on this CHOICE option that actually selects the Message structure based on a tag. But everything looks good in print... |
|
| Back to top |
|
|
| cute_pav |
| Posted: Wed Nov 13, 2002 1:20 pm Post subject: |
|
|
Acolyte
Joined: 04 Jan 2002
Posts: 65
Location: usa
|
Hi,
few implementation details:
If you know abt the each record length of this message, you can very well go with BLOB -> MRM -> XML(IDOC).
Tag/delimeter is possible and best opted(in obsence of unknown record length) for MRM with available delimeter constraints.
By the way, what is your delimer for each record and each message?
pavan |
|
| Back to top |
|
|
| mmarq |
| Posted: Wed Nov 13, 2002 1:43 pm Post subject: Trimming spaces out of the middle of a string |
|
|
Acolyte
Joined: 19 Sep 2002
Posts: 74
Location: Newton, MA
|
I get an email address and I need to be able to strip out the spaces where ever they occur.
trim only does leading and trailing - any way to trim out of the middle?
billybob@abc news.COM
Thanks,
Melissa
_________________
M Marquis |
|
| Back to top |
|
|
| cute_pav |
| Posted: Wed Nov 13, 2002 1:57 pm Post subject: |
|
|
Acolyte
Joined: 04 Jan 2002
Posts: 65
Location: usa
|
melissa,
trim works only at the the ends.If at all you want to remove are replace spaces from field, write a fuction using position,overlay and substring.
pavan |
|
| Back to top |
|
|
| mmarq |
| Posted: Wed Nov 13, 2002 2:39 pm Post subject: Reply |
|
|
Acolyte
Joined: 19 Sep 2002
Posts: 74
Location: Newton, MA
|
I was afraid that was the answer ....
yuk!
You know, ESQL needs regular expression matching BAAAAAADDD
Thanks for the reply,
Melissa
_________________
M Marquis |
|
| Back to top |
|
|
| migstr |
| Posted: Wed Nov 13, 2002 3:32 pm Post subject: |
|
|
Apprentice
Joined: 05 Jun 2002
Posts: 34
Location: New York
|
Not sure what happened with the original tagged/delimited question, anyway... The delimiter for each record will be different, it identifies the structure that should be used to read the data, like this:
For each Message
HEADER01xxxxxxDETA0001xxxxxxxDETA0001xxxxxxxDETB0001xxxx
DETC0001xxxxxxDETD0001xxx
so HEADER01, DETA001, DETB001,DETC0001, DETD0001 are the dilimiters, I can have 12 different kinds. All are 8 characters in length and the structures they define are all fixed length.
So you think this is possible using Tagged/Delimited MRM? |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Nov 14, 2002 7:49 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Since your delimiters are different, I think you should use CWF format instead.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
