Re: XML-INTO and NULL

If you want to fully understand this check out my article on the subject (
https://authory.com/JonParisAndSusanGantner/XML-INTO-Revisited <
https://authory.com/JonParisAndSusanGantner/XML-INTO-Revisited>) the
relevant portion that you need is titled: Problem 1: Data and Attributes at
the Same Level.

I suspect that since, unlike JSON, XML doesn't have a notion of null and
so the designers of this rather strange schema have elected to use an
attribute to indicate a null value (as opposed to a zero value). Most XML I
have seen in the past achieves this by simply omitting the element - why
your designers went this odd route who knows?

I'm guessing that they never send data like this:

<element nil="false"> 1234 </element>

but rather simply send:

<element> 1234 </element>

Attributes are treated hierarchically the same as children of the element
which means the parent has to be a DS - but that causes issues when there
is data as well as attributes as the article explains. Now in your case,
it looks as if you probably have _either_ an attribute _or_ data - but
XML-INTO can't know that. So you have to build the DS as if both data and
attributes can be present.

As with any "missing" element, the default values of the DS fields will
not be changed. So ...

<element> 1234 </element> would result in element.data containing the
value 1234 and element.nil containing its initial value.

<element nil="true"/> or <element nil="true"></element> (which are
basically the same thing) element.data will have its initial value and
element.nil will contain the value true.

Hope this helps


Jon P

On Mar 10, 2023, at 3:35 PM, K Crawford <kscx3ksc@xxxxxxxxx> wrote:

Jon.
In the example what would come back in 'AverageDailyBalance' if it were
null?
I will give this a try.

On Fri, Mar 10, 2023 at 8:48 AM Jon Paris <jon.paris@xxxxxxxxxxxxxx>

wrote:

You have two problems here.

As Vern has pointed out there are namespaces being used which you are

not

handling. In this case adding the option ns=remove will handle that.

But the specific problem you described is caused by an incorrect data
definition. Elements such as AverageDailyBalance that contain an

attribute

such as nil="true" require that they be defined as a DS as "nil" is a

child

of AverageDailyBalance. But you also seem to expect the element to
sometimes contain a value so you also need to add the datasubf option. I
have assumed datasubf=data in the minimum definition shown here:

Changes

in bold spacing probably not accurate.

dcl-ds Balance qualified;
Type varchar(50);
OpeningBalance zoned(24:4) inz(0);
ClosingBalance zoned(24:4) inz(0);
dcl-ds AverageDailyBalance;
nil char(4);
data zoned(24:4) inz(0);
end-ds;
dcl-ds AnnulPercentageYield;
nil char(4);
data zoned(24:4) inz(0);
end-ds;
BalanceAsOf varchar(50);
End-Ds Balance;

A word of advice - don't use allowextra=yes and allowmissing=yes unless
you actually need them. Particularly when testing they will tend to mask
the real problems as I suspect they did here.


Jon P.

P.S. I'm going to ignore Vern's outrageous remarks about SQL <grin>

On Mar 9, 2023, at 5:11 PM, K Crawford <kscx3ksc@xxxxxxxxx> wrote:

I have a program that is using XML-INTO The XML has a null value. How

do I

handle that?
I searched the archive and everything there is over 10 years old and...

This is the error I get:
The XML document does not match the RPG variable; reason code 8.
Message ID . . . . . . : RNX0353 Severity . . . . . . . : 50

Message type . . . . . : Escape

Date sent . . . . . . : 03/09/23 Time sent . . . . . . :
15:07:01
Message . . . . : The XML document does not match the RPG variable;
reason code 8.

example code:
dcl-s XmlDocument varchar(1000);
dcl-c xmlinto_options
const('case=any doc=file countprefix=ArrCnt_ +
allowmissing=yes allowextra=yes');
dcl-ds Balance;
Type varchar(50);
OpeningBalance zoned(24:4) inz(0);
ClosingBalance zoned(24:4) inz(0);
AverageDailyBalance zoned(24:4) inz(0);
AnnulPercentageYield zoned(24:4) inz(0);
BalanceAsOf varchar(50);
End-Ds Balance;

This is the line of code that the error is issued on.
xml-into GetFundedAccountStatementDetailsResponse %xml(Xmldocument:
xmlinto_options);

This is the XML:
<Balance>
<Type>Total Balance</Type>
<OpeningBalance>2904.5100</OpeningBalance>
<ClosingBalance>3854.9800</ClosingBalance>
<AverageDailyBalance i:nil="true" />
<AnnualPercentageYield i:nil="true" />
<BalanceAsOf>2023-01-31T00:00:00</BalanceAsOf>
</Balance>

Thanks for your help.
--
KCrawford
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

--
KCrawford
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.