| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| accessing MQMD.PutTime in WMQI |
« View previous topic :: View next topic » |
| Author |
Message
|
| kwelch |
 Posted: Fri Sep 05, 2003 4:04 am Post subject: accessing MQMD.PutTime in WMQI |
 |
|
Master
Joined: 16 May 2001
Posts: 255
|
Hi,
When I look at the MQMD messagest in WMQI it has the PutTime described as STRING fixed format of 8 characters. We also have an application that displays PutTime and the display shows this: '12345678'.
However, when I try to pull out the last two bytes of this string(7 using the SUBSTRING command, I get an error saying that it's an invalid type that I can't do a substring on type GMTTIME "'GMTTIME 12:34:45.678'".
How I got around this was by using CAST to STRING then CAST to INTEGER and doing my calculation. So problem is solved but I don't understand why WMQI thinks this is a GMTTIME format. Can anyone explain this to me????? Thanks.
Karen |
|
| Back to top |
|
 |
| Craig B |
| Posted: Fri Sep 05, 2003 4:31 am Post subject: |
|
|
Partisan
Joined: 18 Jun 2003
Posts: 316
Location: UK
|
Hi,
If you are mamipulating the MQMD.PutTime field then this is a timestamp field within ESQL and therefore will be treated as one. The MRMs MQMD messageSet has this field as a string because these were created before V2.1. In versions of WMQI prior to V2.1, there was no DATETIME datatype in the MRM and therefore this had to be modelled as string data.
Are you manipulating the MQMD.PutTime field in your scenario? Or are you manipulating a messageSet where you have defined this as a STRING. This was not clear to me in your description. If you are manipulating the MQMD PutTime then this will be a Timestamp field. If it is your own MRM messageSet field, could you provide details of your MRM messageSet and how this field is manipulated through your flow.
_________________
Regards
Craig |
|
| Back to top |
|
|
| kwelch |
| Posted: Fri Sep 05, 2003 4:41 am Post subject: |
|
|
Master
Joined: 16 May 2001
Posts: 255
|
Hi Craig,
I am accessing the MQMD.PutTime field on the input message and I am at WMQI V2.1 and WMQI is recognizing it as a GMTTIME but the MQMD messageset does say string fixed length 8 chars. If I understand you correctly, you are saying that the MQMD messageset does not reflect the V2.1 types within ESQL and I should not rely on it as a reference when I try to manipulate fields in the MQMD? Thanks!
Karen |
|
| Back to top |
|
|
| Craig B |
| Posted: Fri Sep 05, 2003 4:45 am Post subject: |
|
|
Partisan
Joined: 18 Jun 2003
Posts: 316
Location: UK
|
Hi,
Yes ... your understanding is correct. WMQI does not use the MRM MQMD messageSet to parse its MQMD, and it does not use any of the other MRM header definitions to parse the other headers. WMQI has a builtin parser to handle each of the recognised headers, and therefore there is an MQMD parser to parse the MQMD. If you are interested in what datatypes are produced for each field, then the Working With Messages book has an Appendix which lists the field Names and datatypes of the fields that are created by these parsers.
Hope this helps.
_________________
Regards
Craig |
|
| Back to top |
|
|
| kwelch |
| Posted: Fri Sep 05, 2003 4:51 am Post subject: |
|
|
Master
Joined: 16 May 2001
Posts: 255
|
Craig,
Thanks! As with all my posts you answer you have made things clear.
Karen |
|
| 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
|
|
|
|
