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!
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?
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
Kendallville, IN 46755
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,
Sent by: midrange-l-bounces@xxxxxxxxxxxx
I've searched the IBM manuals and the archives to no avail. Here are the
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>' ||
as CLOB(1m))) ||
When I run it, I get the following results in parm_xml1:
When another runs it, this is the result:
Note that the parameters that are in the XMLElement() function
become...unusual. Any ideas?
Northland Insurance - A [trav_CMYK_0_100_99_4] Company
385 Washington Street, SB03N
St. Paul, MN 55102
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.