| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Generate the MQRFH2.jms.Tms value from within a flow |
« View previous topic :: View next topic » |
| Author |
Message
|
| wolstek |
 Posted: Mon Jun 13, 2005 10:32 am Post subject: Generate the MQRFH2.jms.Tms value from within a flow |
 |
|
Acolyte
Joined: 25 Jun 2001
Posts: 52
Location: Bristol, UK
|
My flow accepts an XMLNS message containing an MQRFH2 with jms. (WBIMB V5)
When I output the message to another queue, I want to update the Root.MQRFH2.jms.Tms (timestamp) value to reflect the actual put date/time.
I am unable to establish how to format the value required (which should look something like 111886533577, i.e some java timestamp format)
I have updated the MQMD.PutDate = CURRENT_DATE and MQMD PutTime = CURRENT_GMTTIME with "Message Context = Set All" on the MQOutput Node. This correctly sets the message putdate/time on the queue, but cannot establish how to do the Tms bit.
Is there some clever formatting that can be done in eSQL, are there other node properties that I can set to do it for me, or can I invoke a java method to do it for me, if so how would I go about that.
Any help gratefully appreciated.
Many Thanks |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Jun 13, 2005 10:37 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I think you want the EXTRACT function.
Or a series of substring/positions on the results of casting a datetime to a string.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wolstek |
| Posted: Mon Jun 13, 2005 10:42 am Post subject: |
|
|
Acolyte
Joined: 25 Jun 2001
Posts: 52
Location: Bristol, UK
|
I'm not sure that that applies in this case as I think that the Tms is a timestamp based on millisecs against a reference point or some other java internal format, which I am not sure.
For example the Tms value 1118684322711 represents a date-time of
2005-06-13-18.38.42.711
The normal extract will not give me these values. (will it ?) |
|
| 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
|
|
|
|
