You can also set the CCSID on the SBMJOB command.

From: "John Rusling via RPG400-L" <rpg400-l@xxxxxxxxxxxxxxxxxx>
To: "Jack Woehr" <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
Cc: "John Rusling" <JRusling@xxxxxxxxxxx>, "RPG programming on IBM i"
Date: 25/11/2021 06:23 AM
Subject: RE: Using qsys2.ifs_read table function in RPG pgm and
getting SQL0332 Character conversion message.
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>

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.



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<;!!JAIo9NhAvg!-vF5w2VvfPqvoeydc9yry8Wd91-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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 by 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.