| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How do I set a NULL field in CWF |
« View previous topic :: View next topic » |
| Author |
Message
|
| berguss22 |
 Posted: Sun Dec 26, 2004 2:14 am Post subject: How do I set a NULL field in CWF |
 |
|
Apprentice
Joined: 10 Mar 2004
Posts: 31
|
| I am converting from XML to CWF I want to set one of the output fields to Null...Pad it with spaces. How do I do that in esql and the properties of the field itself |
|
| Back to top |
|
 |
| kirani |
| Posted: Sun Dec 26, 2004 11:25 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
What is your field type? And what exactly do you mean by assigning NULL value to this field. Do you mean that you want to assign X'00' to this field? If your field is defined as CHAR then you can CAST X'00' as CHAR (using CCSID option) and assign the value to this MRM element. You can set the padding in your message set.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Dec 27, 2004 5:25 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Or you can use the VALUE clause to assign the VALUE of an element to the logical NULL value, instead of assigning the element itself to be a logical NULL, which deletes the element.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Dec 27, 2004 10:06 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
One more option would be to assign a default value to this element in your MessageSet itself.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
