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

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>' ||
XMLelement(name "action",:parmaction),
XMLelement(name "contractNumber",:parmcon))
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?

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

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.


This thread ...


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