ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Mesaage ID extraction using ESQL

Post new topic  Reply to topic
 Mesaage ID extraction using ESQL « View previous topic :: View next topic » 
Author Message
guddi
PostPosted: Thu Jul 15, 2010 10:56 am    Post subject: Mesaage ID extraction using ESQL Reply with quote

Newbie

Joined: 15 Jul 2010
Posts: 5
Hi,

I am new to ESQL coding. I have a requirement to extract the last 5 digits of an incoming Message ID (48 chars in hex) using ESQL coding. Could someone please help with a sample eqsl code.

Thanks in advance.
Guddi
Back to top
View user's profile Send private message
Gaya3
PostPosted: Thu Jul 15, 2010 11:11 am    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
there are lot of string functions available in ESQL

SUBSTRING function will help you out in this case.

look@
http://publib.boulder.ibm.com/infocenter/wmbhelp/v7r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/ak05260_.htm

I dont want to give a hint about how to retrieve Message ID from the message,

i suggest you to dig on it, get a trace and understand about it.

go ahead learn, its a great product
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Jul 15, 2010 11:27 am    Post subject: Re: Mesaage ID extraction using ESQL Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
guddi wrote:
I have a requirement to extract the last 5 digits of an incoming Message ID (48 chars in hex) using ESQL coding.


If the message id is system generated (as it should be for reasons discussed many times in here) then I struggle to see what value this could add. Why this requirement?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
guddi
PostPosted: Thu Jul 15, 2010 9:53 pm    Post subject: Reply with quote

Newbie

Joined: 15 Jul 2010
Posts: 5
When I calulate length of message ID, it shows length as 24 which is binary length. I want to calculate Hex length which is 48. how to cod ethat in ESQL.
Back to top
View user's profile Send private message
guddi
PostPosted: Thu Jul 15, 2010 11:21 pm    Post subject: Reply with quote

Newbie

Joined: 15 Jul 2010
Posts: 5
I have completed that. It was an easy ESQL code. Thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Mesaage ID extraction using ESQL
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.