| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Customized DATETIME format in MRM |
« View previous topic :: View next topic » |
| Author |
Message
|
| jimliu |
 Posted: Mon Aug 12, 2002 10:25 am Post subject: Customized DATETIME format in MRM |
 |
|
Novice
Joined: 19 Dec 2001
Posts: 12
|
Hi,
I'm trying to transform an XML message (imported from DTD) into a TAG message both stored in the MRM. I have two fields for the TAG format, Creation Date and Creation Time which I am trying to transform to from an XML field with format "yyyy-mm-ddThh:mm:ssZ". The Creation Date should be of format "YYYYMMDD" while the Creation Time should be "HHMMSS".
I've been reading that the TAG tab (after adding the TDS format layer) for those two DATETIME fields have a entry called format. How exactly do I input the format I want to get into there? I've tried just adding 'yyyyMMdd' and 'hhMMss' without the quotes because I saw a similar example elsewhere but WMQI is giving me an error in the event log:
( SIPBK02.default ) Data Length Error
Data length inconsistent with element definition while writing a TDF message. Element name: 'CreationDate' Element type: STRING Expected data length: 8 Actual data length: 10 Data: 00/00/0000
Make sure that the length of specified binary data item is the same as the expected length, as defined in the message definition or that the length of specified string data item is not greater than the expected length.
How exactly do I this? Should I be adding quotes? Or should everything be capital? Will this even work this way or am I making this up in my head?
Any help would be greatly appreciated...
Jim |
|
| Back to top |
|
 |
| Miriam Kaestner |
| Posted: Tue Aug 13, 2002 1:33 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2001
Posts: 103
Location: IBM IT Education Services, Germany
|
| Your elements must be of simple type DATETIME, not STRING. |
|
| Back to top |
|
|
| jimliu |
| Posted: Tue Aug 13, 2002 5:26 am Post subject: |
|
|
Novice
Joined: 19 Dec 2001
Posts: 12
|
They are defined as DATETIME, not STRING, which is making me even more confused. I'm not sure why the format in the error is saying it should be length 10 with format "00/00/0000" when my inputted format is either "yyyyMMdd" or "hhMMss". Unless the syntax is wrong...
Jim |
|
| 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
|
|
|
|
