| 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: 1647
|
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 |
|
|
|
|
