Author |
Message
|
sboucher |
Posted: Wed May 20, 2009 2:28 pm Post subject: Filter Node MQSI 2.1 |
|
|
Acolyte
Joined: 27 Oct 2002 Posts: 52
|
I want to do what seems to be ridculously simple but not having success:
My input message is just a binary stream. The first two characters of the message determines the output Q. Here is an example message:
20090520...... Goes to Numeric Q
TH20090520..... Goes to Alpha Q
I only want to process messages beginning with TH with the rest going to aa FAIL Q. I tried doing this within a Filter node:
SUBSTRING("Body" from 1 for 2)='TH'
All the examples I have seen have a predefined message format such as XML...not too sure what even to SUBSTRING. Message Format is set to MQSTR. I do not have any Domain defined on my MQSI Input Node
I hope somone can help me...my expertise is in databases
Scott _________________ Scott A. Boucher
Database Administartor |
|
Back to top |
|
 |
Gaya3 |
Posted: Wed May 20, 2009 9:59 pm Post subject: |
|
|
 Jedi
Joined: 12 Sep 2006 Posts: 2493 Location: Boston, US
|
if you havent defined any Domain, it will be by default take it as "BLOB".
I really wonder that you are using MQSI V2.1, or is it a typo Error _________________ Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
Back to top |
|
 |
mgk |
Posted: Thu May 21, 2009 12:30 am Post subject: |
|
|
 Padawan
Joined: 31 Jul 2003 Posts: 1642
|
It has been a long time since I used 2.1, and the syntax has changed a little with later releases. That said, try:
SUBSTRING(Root.BLOB.BLOB FROM 1 FOR 2) = CAST( 'TH' AS BLOB CCSID 1208)
BTW, if you are using 2.1, do you know it is out of support?
Regards,
MGK _________________ MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
Back to top |
|
 |
sboucher |
Posted: Thu May 21, 2009 2:17 am Post subject: |
|
|
Acolyte
Joined: 27 Oct 2002 Posts: 52
|
Gaya3 wrote: |
if you havent defined any Domain, it will be by default take it as "BLOB".
I really wonder that you are using MQSI V2.1, or is it a typo Error |
Unfortunately this is not a Typo...Just one of those apps ready to die that doesn't warrant an upgrade _________________ Scott A. Boucher
Database Administartor |
|
Back to top |
|
 |
Vitor |
Posted: Thu May 21, 2009 2:20 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
sboucher wrote: |
Just one of those apps ready to die that doesn't warrant an upgrade |
MQSI v2.1 warrants an upgrade by the simple fact of being v2.1
Despite the near-death status of the app using it, v2.1 is not just dead, it's buried. And was contact admin when it was alive. Put a stake through it's heart for all our sakes.  _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
sboucher |
Posted: Thu May 21, 2009 3:42 am Post subject: |
|
|
Acolyte
Joined: 27 Oct 2002 Posts: 52
|
mgk wrote: |
It has been a long time since I used 2.1, and the syntax has changed a little with later releases. That said, try:
SUBSTRING(Root.BLOB.BLOB FROM 1 FOR 2) = CAST( 'TH' AS BLOB CCSID 1208)
BTW, if you are using 2.1, do you know it is out of support?
Regards,
MGK |
Thanks so much...This worked perfectly _________________ Scott A. Boucher
Database Administartor |
|
Back to top |
|
 |
rekarm01 |
Posted: Mon May 25, 2009 2:36 pm Post subject: Re: Filter Node MQSI 2.1 |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 1415
|
Gaya3 wrote: |
I really wonder that you are using MQSI V2.1, or is it a typo Error |
It's still a typo, either way; it would be easier to keep track of the product names if they didn't keep changing:- MQSI v2.0.x
- WMQI v2.1
- WBI MB v5.0
- WMB v6.x
Now, if someone could please sort out the names in the forum title ...  |
|
Back to top |
|
 |
|