Re: Problem with SQL-ing systools.group_ptf_currency

On 02-Oct-2015 00:49 -0600, Szepesi Frigyes wrote:

<<SNIP>>
I wanted to test the possibility to check my PTF level currency
mentioned here:

http://www.itjungle.com/fhg/fhg080415-story03.html

The article mentions this SQL statement to invoke this function:

SELECT * FROM systools.group_ptf_currency

I also changed my job's CCSID to 37. The SQL statement does not
work, joblog:

User-defined function error on member GRPPTFCUR.
Cancel reply received for message CPF503E.

Details of the first entry:

Message ID . . . : CPF503E Severity . . . . : 30
Message type . . : Diagnostic
Date sent . . . : 02/10/15 Time sent . . . : 08:46:16
Message . . : User-defined function error on member GRPPTFCUR.
Cause . . . : An error occurred while invoking user-defined
function XMLPARSE in library QSYS2. The error occurred while
invoking the associated external program or service program
XMLPARSE in library QSYS, program entry point or external name
QQXMLPARSE, specific name *N. The error occurred on member
GRPPTFCUR file GRPPTFCUR in library SYSTOOLS. The error code is 1.
The error codes and their meanings follow:
1 -- The external program or service program returned
SQLSTATE 2200M. The text message returned from the program is:
­­­­­­­Ę­áThe element type "head" does not match the expected
end-tag "</META>" .

Is there anything I need to do? I did not have the time to go
through all the cover letters contained the group.

Was CCSID(37) chosen merely per the comment in the article that "For most of us in the U.S. CCSID of 37 is appropriate."? And if so, does the language environment of that system actually match that of the typical USA settings, or perhaps the installed Primary Language is something other than USEnglish, and thus the Language Identifier (LANGID) established by default is other than LANGID(ENU)?

From the /signature/ included in a more recent followup reply [showing characters that do not appear in CP00037], that the system would closely match with USA settings seems improbable; more likely using LANGID(HUN) and thus the likely expected Default CCSID(870)?