Thanks Stefan.

Didn't know that so I looked and 4 page downs later there it is . .
Language identifier . . . . . . . . . . . : *SYSVAL
Country or region identifier . . . . . . . : *SYSVAL
Coded character set identifier . . . . . . : *SYSVAL
Character identifier control . . . . . . . : *SYSVAL
Locale job attributes . . . . . . . . . . : *SYSVAL

John

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of stefan@xxxxxxxxxx
Sent: Wednesday, November 24, 2021 2:27 PM
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Using qsys2.ifs_read table function in RPG pgm and getting SQL0332 Character conversion message.

You can set CCSID on the userprofile

Best regards

Stefan

--
No trees were killed in the sending of this message, but a large number of electrons were terribly upset.

Stefan Tageson
+46 732 369934
stefan@xxxxxxxxxx

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of John Rusling via RPG400-L
Sent: Wednesday, November 24, 2021 9:23 PM
To: Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
Cc: John Rusling <JRusling@xxxxxxxxxxx>; RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Using qsys2.ifs_read table function in RPG pgm and getting
SQL0332 Character conversion message.

Hi Jack,

Executing CHGJOB CCSID(37) on program initialization works.
Not fond of it, seems kludgy but we use what works.

I did not see a place in the JOBD for setting the CCSID.

Thanks,

John

From: Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
Sent: Wednesday, November 24, 2021 1:46 PM
To: John Rusling <JRusling@xxxxxxxxxxx>
Cc: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Using qsys2.ifs_read table function in RPG pgm and getting
SQL0332 Character conversion message.



On Wed, Nov 24, 2021 at 12:29 PM John Rusling <JRusling@xxxxxxxxxxx<mailto:JRusling@xxxxxxxxxxx>> wrote:
Do you know - is there a different way to go about this, because all I can think to do is execute CHGJOB CCSID(37) in the program at initialization
(maybe) using qcmdexec ?
(what I'll probly try next)


Someone better informed than I am about this sort of thing may have a solution, but CHGJOB or running your jobs under a JOBD with that CCSID sounds like the easiest.

--
Jack Woehr, IBM Champion
2021<https://urldefense.com/v3/__https:/www.youracclaim.com/badges/528d23d6-
087f-4698-8d17-d59688106ac4/public_url__;!!JAIo9NhAvg!-vF5w2VvfPqvoeydc9yry8
Wd91-FkMVUnNzMwIQiuT0xN1MKFSO1GnLbYct5XzjH$>
Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021

NON-DISCLOSURE NOTICE: This communication including any and all attachments is for the intended recipient(s) only and may contain confidential and privileged information. If you are not the intended recipient of this communication, any disclosure, copying further distribution or use of this communication is prohibited. If you received this communication in error, please contact the sender and delete/destroy all copies of this communication immediately.
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinfo/rpg400-l__;!!JAIo9NhAvg!_kMEZNLQ4aqMPEXQMgzrydShxBpMd4Ec_Ut4rvGZBmiv4FW3U29KN7PKtUOZlMT5$
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.com/v3/__https://archive.midrange.com/rpg400-l__;!!JAIo9NhAvg!_kMEZNLQ4aqMPEXQMgzrydShxBpMd4Ec_Ut4rvGZBmiv4FW3U29KN7PKtUdEfIfW$ .

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://urldefense.com/v3/__https://amazon.midrange.com__;!!JAIo9NhAvg!_kMEZNLQ4aqMPEXQMgzrydShxBpMd4Ec_Ut4rvGZBmiv4FW3U29KN7PKtUOGeAyC$

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinfo/rpg400-l__;!!JAIo9NhAvg!_kMEZNLQ4aqMPEXQMgzrydShxBpMd4Ec_Ut4rvGZBmiv4FW3U29KN7PKtUOZlMT5$
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.com/v3/__https://archive.midrange.com/rpg400-l__;!!JAIo9NhAvg!_kMEZNLQ4aqMPEXQMgzrydShxBpMd4Ec_Ut4rvGZBmiv4FW3U29KN7PKtUdEfIfW$ .

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.com/v3/__https://amazon.midrange.com__;!!JAIo9NhAvg!_kMEZNLQ4aqMPEXQMgzrydShxBpMd4Ec_Ut4rvGZBmiv4FW3U29KN7PKtUOGeAyC$

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.