DB2 v10 z/OS - SOAPHTTPNC and XMLTABLE tag markers (escaped vs non-escaped)

Natalie Faulkner

DB2 v10 z/OS - SOAPHTTPNC and XMLTABLE tag markers (escaped vs non-escaped)

Populating a table/XML column by calling SOAPHTTPNC and pulling data from a web service.

The tags in the XML column are inserted with "&lt;" and "&gt;" surrounding them instead of the expected "<" and ">".  The XMLTABLE function is not recognizing the tags; therefore, the SELECT is returning NULLS.  I modified one row to use the "<" and ">" and the XMLTABLE function works as expected.

Is this something that needs addressed at the web service level, the call of SOAPHTTPNC, or the SELECT using the XMLTABLE function.

 

Thanks for your assistance.

Natalie

James Campbell

DB2 v10 z/OS - SOAPHTTPNC and XMLTABLE tag markers (escaped vs non-escaped)
(in response to Natalie Faulkner)
I know I am old, and my eye sight is failing, but the greater-than and less-than signs in

> with "<" and ">" surrounding them

look identical to

> the expected "<" and ">". 

Am I missing something? Perhaps if you gave us the Unicode values of the two sets.

James Campbell


On 28 Feb 2017 at 12:07, Natalie Faulkner wrote:

>
> Populating a table/XML column by calling SOAPHTTPNC and pulling data from a web service.
> The tags in the XML column are inserted with "<" and ">" surrounding them instead of the
> expected "<" and ">".  The XMLTABLE function is not recognizing the tags; therefore, the
> SELECT is returning NULLS.  I modified one row to use the "<" and ">" and the XMLTABLE
> function works as expected.
> Is this something that needs addressed at the web service level, the call of SOAPHTTPNC, or
> the SELECT using the XMLTABLE function.
>  
> Thanks for your assistance.
> Natalie
>
>
> Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list  
> Manage your subscription  
>
> This email has been sent to: [login to unmask email]
> ** ** ** Attend the 2017 IDUG Tech Conference North America ** ** **
> ---> Anaheim, California, April 30 - May 04, 2017 <---
> http://www.idug.org/na
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2016.0.7998 / Virus Database: 4756/14033 - Release Date: 02/27/17


Natalie Faulkner

DB2 v10 z/OS - SOAPHTTPNC and XMLTABLE tag markers (escaped vs non-escaped)
(in response to James Campbell)
I guess it is translating to the correct < and >!!!!

Without the spaces - It is "& l t ;" and "& g t ;"



From: James Campbell [mailto:[login to unmask email]
Sent: Tuesday, February 28, 2017 3:33 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 v10 z/OS - SOAPHTTPNC and XMLTABLE tag markers (escaped vs non-escaped)

I know I am old, and my eye sight is failing, but the greater-than and less-than signs in

> with "<" and ">" surrounding them

look identical to

> the expected "<" and ">".

Am I missing something? Perhaps if you gave us the Unicode values of the two sets.

James Campbell


On 28 Feb 2017 at 12:07, Natalie Faulkner wrote:

>
> Populating a table/XML column by calling SOAPHTTPNC and pulling data from a web service.
> The tags in the XML column are inserted with "<" and ">" surrounding them instead of the
> expected "<" and ">". The XMLTABLE function is not recognizing the tags; therefore, the
> SELECT is returning NULLS. I modified one row to use the "<" and ">" and the XMLTABLE
> function works as expected.
> Is this something that needs addressed at the web service level, the call of SOAPHTTPNC, or
> the SELECT using the XMLTABLE function.
>
> Thanks for your assistance.
> Natalie
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list
> Manage your subscription
>
> This email has been sent to: [login to unmask email]<mailto:[login to unmask email]>
> ** ** ** Attend the 2017 IDUG Tech Conference North America ** ** **
> ---> Anaheim, California, April 30 - May 04, 2017 <---
> http://www.idug.org/na
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>
> No virus found in this message.
> Checked by AVG - www.avg.com<http://www.avg.com>
> Version: 2016.0.7998 / Virus Database: 4756/14033 - Release Date: 02/27/17



-----End Original Message-----

James Campbell

DB2 v10 z/OS - SOAPHTTPNC and XMLTABLE tag markers (escaped vs non-escaped)
(in response to Natalie Faulkner)
If all else fails, perhaps

REPLACE(REPLACE(SOAPHTTPNC(...), '& lt.' , '<'), '& gt.','>')
(like you, without the spaces after the ampersands)

will kludge around the problem.

https://bytes.com/topic/net/answers/492941-replacing-lt-using-xslt
has a suggestion of adding
<xsl:value-of select="text()" disable-output-escaping="yes"/>
to a SOAP request. But it might depend on the exact request.

James Campbell

On 28 Feb 2017 at 20:50, Faulkner, Natalie W wrote:

>
> I guess it is translating to the correct < and >!!!!
>  
> Without the spaces - It is "& l t ;" and "& g t ;"
>  
>  
>  
> From: James Campbell [mailto:[login to unmask email]
> Sent: Tuesday, February 28, 2017 3:33 PM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: DB2 v10 z/OS - SOAPHTTPNC and XMLTABLE tag markers
> (escaped vs non-escaped)
>  
> I know I am old, and my eye sight is failing, but the greater-than and less-than signs in
>  
> >with "<" and ">" surrounding them
>  
> look identical to
>  
> >the expected "<" and ">". 
>  
> Am I missing something?  Perhaps if you gave us the Unicode values of the two sets.
>  
> James Campbell
>  
>  
> On 28 Feb 2017 at 12:07, Natalie Faulkner wrote:
>  
> >
> > Populating a table/XML column by calling SOAPHTTPNC and pulling data from a web service.
> > The tags in the XML column are inserted with "<" and ">" surrounding them instead of the
> > expected "<" and ">".  The XMLTABLE function is not recognizing the tags; therefore, the
> > SELECT is returning NULLS.  I modified one row to use the "<" and ">" and the XMLTABLE
> > function works as expected.
> > Is this something that needs addressed at the web service level, the call of SOAPHTTPNC, or
> > the SELECT using the XMLTABLE function.
> >  
> > Thanks for your assistance.
> > Natalie
> >
> >
> > Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this
> mailing list  
> > Manage your subscription  
> >
> > This email has been sent to: [login to unmask email]
> > ** ** ** Attend the 2017 IDUG Tech Conference North America ** ** **
> > ---> Anaheim, California, April 30 - May 04, 2017 <---
> > http://www.idug.org/na
> >
> > Use of this email content is governed by the terms of service at:
> > http://www.idug.org/p/cm/ld/fid=2
> >
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2016.0.7998 / Virus Database: 4756/14033 - Release Date: 02/27/17
>  
>   
>  
> -----End Original Message-----
>
>
> Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  
>
> This email has been sent to: [login to unmask email]
> ** ** ** Attend the 2017 IDUG Tech Conference North America ** ** **
> ---> Anaheim, California, April 30 - May 04, 2017 <---
> http://www.idug.org/na
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2016.0.7998 / Virus Database: 4756/14037 - Release Date: 02/28/17