Joined: 04 Nov 2001 Posts: 10 Location: Waterloo Ontario
Is there any way, via the message set facility, to define a DEFAULT value for a given element. Our problem is that we are producing MRM out of XML, and if the XML tag does not exist OR it exists but has no data then we are forced to wrap a COALESCE(CAST...) function around the field or else you get the old 'UNEXPECTED NULL VALUE ENCOUNTERED' message on the output node.
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