Re: XML-INTO - %XML option to treat null element as 0

On Tue, 5 Mar 2013, at 16:13:38, darren@xxxxxxxxx wrote:

First thing to try would be to put an INZ on your data structure
definition. That will initialize the numeric to zero. What options are
you using? I use the following, and I don't ever expect a numeric. I
convert the character to numeric in a later operation when required,
although that doesn't mean what you're trying isn't possible:

+ 'allowmissing=yes '
+ 'allowextra=yes '
+ 'case=any');

For any of you still using these options as your default you really should take a look at the new options such as countprefix - there is rarely ever a need to use allowmissing/extra any more and unless you are validating the XML prior to running XML-INTO you are taking a real risk of missing required elements. Heck the document could be all but empty and it would rn without error.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com