Posted: Thu Jan 08, 2009 8:51 pm Post subject: null DATETIME MRM parse error
Apprentice
Joined: 21 Jul 2003 Posts: 34
WBI/MB 6.1 on AIX
The MRM parser on an MQ input node successfully parses a DATETIME element of type fixed string length.
Padding character is set to SPACE
Representation of null values is NullLiteralFill with the encoding null value set to SPACE
Everything else is basically default. The goal of the above is parse actual date/time data but to also allow a 26 byte long string made of spaces to be interpreted by the parser as a NULL DATETIME
The parser successfully parses actual date/times in the yyyy-MM-dd'T'HH:mm format, but throws a parsing exception when it is passed spaces.
The WBI/MB infocenter documentation I have read implies, in my opinion, that the above combination of settings should allow spaces to be passed as a null date/time. Is this not the case?
Any suggestion on how to fix or alternatively pass a null date would be appreciated.
thank you advance for your time in reviewing this.
Check your message set if you have specific null settings in the data/time section. Check as well if you have "strict date time" turned on or off. _________________ MQ & Broker admin
The WBI/MB infocenter documentation I have read implies, in my opinion, that the above combination of settings should allow spaces to be passed as a null date/time. Is this not the case?
I disagree. The infocenter clearly states that you also need to set the 'nillable' property on the element/attribute.
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