| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| CWF Field with dateTime Type - How to accept spaces? |
View previous topic :: View next topic |
| Author |
Message
|
| meli7a |
 Posted: Wed Dec 15, 2010 4:08 pm Post subject: CWF Field with dateTime Type - How to accept spaces? |
 |
|
Newbie
Joined: 31 Aug 2009
Posts: 3
|
Hi,
I have created a CWF message set and one of the fields in there is of type ‘dateTime’. This is an optional field and if it does not exist, will come in as a string of spaces.
I would like Broker to be able to accept spaces in the incoming message. However, currently I am getting a parsing error:
“CPI Unable to parse datetime internally”
I’ve set the below properties for my messageset:
- Value: default
- Nillable: checked
- Min/Max occurence 1
Physical Properties :
- Physical Type : Text
- Length : 23
- Length Units : Characters
- Justification : Left
- Padding Char : SPACE
- DateTime Format : dd-MMM-yyyy HH:mm:ss.SS
- Encoding Null : NullLiteralFill
- Encoding Null Value : SPACE
Reading previous thread http://www.mqseries.net/phpBB/viewtopic.php?p=243905&sid=0c6c55f1f40e6772e9440b1ada622705, this settings should work.
Has anyone encountered this, and is there anything I should change in my settings to get it to work?
Thanks. |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Wed Dec 15, 2010 10:33 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Perhaps your error with spaces is due to the fact that you have specified a format pattern for the field?
If you want this then it might be easier to set the field to a string with no pattern and then write some ESQL to manually validate the field. (now I have visions of Kimbert tearing his hair out in anger) 
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| kimbert |
| Posted: Thu Dec 16, 2010 12:32 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
How *exactly* are you specifying the SPACE in the NullLiteralFill property?
The actual value in the property should be <SP> ( no quotes ) |
|
| Back to top |
|
|
| meli7a |
| Posted: Thu Dec 16, 2010 1:17 am Post subject: |
|
|
Newbie
Joined: 31 Aug 2009
Posts: 3
|
Hi guys, thanks for the replies.
I've found out that I can achieve this by changing the below properties:
Encoding Null: NullPadFill
Padding Character: SPACE
In reply to kimbert, when Encoding Null was set to NullLiteralFill, I set the Encoding Null Value to SPACE - given in the dropdown list. I'll give the <SP> a shot and see if that works, too.
Thanks again! |
|
| 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
|
|
|
|
