| Author |
Message
|
| MSV |
 Posted: Wed Mar 21, 2007 8:14 am Post subject: Date format |
 |
|
Acolyte
Joined: 11 Apr 2006
Posts: 59
|
Hi ,
I want to assign a NULL value to a DATE data type within a message definition file.
For this,I have given the following values in the physical properties of the local element:
Padding character value =NUL
Default Date Format =''
But , the following error message is found.
"default value must be type of dd-MM-yyyy"
Could anyone give me a hint.
Note: I dont want to give '01-01-0000' as default value. |
|
| Back to top |
|
 |
| kimbert |
| Posted: Thu Mar 22, 2007 12:33 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
The error message is correct. Default values must be valid for the type of the element. You need to specify a null value. You do not say which physical format you are using, but I'll take a guess that it's XML. You need to
- Set the 'Nillable' property on your element to 'true'
- In the message set properties for XML, set 'Encoding Non-numeric Null' to 'NullEmpty'. |
|
| Back to top |
|
|
| MSV |
| Posted: Thu Mar 22, 2007 5:58 am Post subject: |
|
|
Acolyte
Joined: 11 Apr 2006
Posts: 59
|
Kimbert,
Thanks for the reply.
| kimbert wrote: |
| You do not say which physical format you are using, but I'll take a guess that it's XML. |
My message format is TDS. Environment is MB v5.0.5,Windows 2000.
| kimbert wrote: |
You need to
- Set the 'Nillable' property on your element to 'true'
- In the message set properties for XML, set 'Encoding Non-numeric Null' to 'NullEmpty'. |
As in XML, there is no seperate property in TDS for "representation of null values".
So, In the element's TDS properties, 'Encoding Null' is set to 'NullPadFill'.(I referred ur reply from an adjacent topic which is somewhat related to my post)
"Nillable" property is also set to true.
But still, i am facing the same issue. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Mar 22, 2007 5:42 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
The problem here is that you are trying to force a TDS value to an XML element. This does not work that way...
example date = 0x00000000000000000000; -- for tds would look like
<date xsi:nil = 1></date> in XML
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| broker_new |
| Posted: Fri Mar 23, 2007 2:22 pm Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
Which type of data element separation you are using..
as it depends on that value also...
If it is All elements Delimited there is no need of setting any message defniton properties .
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
| MSV |
| Posted: Mon Mar 26, 2007 5:41 am Post subject: |
|
|
Acolyte
Joined: 11 Apr 2006
Posts: 59
|
| broker_new wrote: |
Which type of data element separation you are using..
as it depends on that value also...
|
Tagged Fixed Length |
|
| Back to top |
|
|
|
|
