MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2013

RESOLVED: SQL-inconsistent results using XMLELEMENT, XMLSERIALIZE, XMLCONCAT



fixed

Rob hit the nail on the head! I set my CCSID to the value their UserProfile has and encountered the same results.

I must have overlooked this setting when comparing the user profiles! My bad!

Thanks Rob!

Steve Needles


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, July 09, 2013 10:22 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL-inconsistent results using XMLELEMENT, XMLSERIALIZE, XMLCONCAT

yet another CCSID issue perhaps?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Needles,Stephen J" <SNEEDLES@xxxxxxxxxxxxxxxx>
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>,
Date: 07/09/2013 11:11 AM
Subject: SQL-inconsistent results using XMLELEMENT, XMLSERIALIZE,
XMLCONCAT
Sent by: midrange-l-bounces@xxxxxxxxxxxx



I've searched the IBM manuals and the archives to no avail. Here are the
particulars...

We are at V7R1 and the user profiles, JOBD's, authority and library lists,
etc. all appear to be correct...that is...the same.

Running this code imbedded in RPG:

.
.
.
parmcon = '1234567890';
parmaction = 'get';

exec sql set :parm_xml1 =
'< XMLGROUP>' ||
trim(xmlserialize(XMLConcat(
XMLelement(name "action",:parmaction),
XMLelement(name "contractNumber",:parmcon))
as CLOB(1m))) ||
'</ XMLGROUP>';
.
.
.

When I run it, I get the following results in parm_xml1:

<XMLGROUP><action>get</action><contractNumber>1234567890</contractNumber></XMLGROUP>

When another runs it, this is the result:

<XMLGROUP><action>h4Wj</action><contractNumber>8fLz9PX29/j58A==</contractNumber></XMLGROUP>

Note that the parameters that are in the XMLElement() function
become...unusual. Any ideas?

Steve Needles
Northland Insurance - A [trav_CMYK_0_100_99_4] Company
Northland Architecture
385 Washington Street, SB03N
St. Paul, MN 55102
Tel: 651-310-4203
sneedles@xxxxxxxxxxxxx<mailto:sneedles@xxxxxxxxxxxxx>

________________________________
This communication, including attachments, is confidential, may be subject
to legal privileges, and is intended for the sole use of the addressee.
Any use, duplication, disclosure or dissemination of this communication,
other than by the addressee, is prohibited. If you have received this
communication in error, please notify the sender immediately and delete or
destroy this communication and all copies.

TRVDiscDefault::1201





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact