| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| To output delimited fields using WMQI 2.0.1 |
« View previous topic :: View next topic » |
| Author |
Message
|
| jg |
 Posted: Fri Apr 04, 2003 9:53 pm Post subject: To output delimited fields using WMQI 2.0.1 |
 |
|
Newbie
Joined: 04 Apr 2003
Posts: 4
|
Is there a way to output a fixed length incoming field with different delimiters in 2.0.1 other than using neon formatter?
For example:
Input Data
FieldA 12345
FieldB abcd
Output Data
FieldA 12345;
FiledB abcd\
Thank you. |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Apr 04, 2003 10:14 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
One way to do this is to define additional fields for Delimiters. For example, define
FIELD1.1 CHAR(1)
FIELD2.1 CHAR(1)
Using ESQL assign different delimiters to these fields.
_________________
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 |
|
|
| kirani |
| Posted: Fri Apr 04, 2003 10:18 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
There use to be a SupportPac with TREEASIS parser, but I am not able to find it on the IBM SupportPac website.
_________________
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 |
|
|
| jg |
| Posted: Fri Apr 04, 2003 10:23 pm Post subject: |
|
|
Newbie
Joined: 04 Apr 2003
Posts: 4
|
Hi Kiran,
Thanks for the reply.
Would you please assist with the ESQL quote?
Thanks. |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Apr 04, 2003 10:28 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Let's say your input msg is parsed using MRM definition (FIELD1 and FIELD2). You could use following code to add delimiters.
| Code: |
SET OutputRoot.MRM.FIELD1 = InputRoot.MRM.FIELD1;
SET OutputRoot.MRM.FIELD11 = ';';
SET OutputRoot.MRM.FIELD2 = InputRoot.MRM.FIELD2;
SET OutputRoot.MRM.FIELD22 = '\';
|
Hope this helps.
_________________
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 |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
