SQL-inconsistent results using XMLELEMENT, XMLSERIALIZE, XMLCONCAT

["Needles,Stephen J" <SNEEDLES@xxxxxxxxxxxxxxxx>]

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