Thanks Jack.
We have such a menagerie of 3rd party software and such in production I wouildn't dare
ask our admin to change the overall sysval ccsid to 37.
I really like the idea of using sql for doing IFS reading, writing and listing folder contents etc.
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)
John
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jack Woehr via RPG400-L
Sent: Wednesday, November 24, 2021 12:26 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Using qsys2.ifs_read table function in RPG pgm and getting SQL0332 Character conversion message.
On Wed, Nov 24, 2021 at 10:19 AM John Rusling via RPG400-L < rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:
This is the error message i get on the prepare -
SQL0332: Character conversion between CCSID 65535 and CCSID 1200
not valid.
I changed the job ccsid in my session thus - CHGJOB CCSID(37) and it works.
fyi We are at V7R3M0 TR7, DSPSYSVAL SYSVAL(QCCSID) reveals 65535.
Any thoughts, suggestions or explanations on why this is happening are
most welcome!
The system is telling you the truth. There's no established conversion between ISO8859-* and the catchall CCSID of 65535.
There is a conversion between ISO8859-* and and CP-037 "good ol' vanilla US English EBCDIC".
IBM has been recommending for decades that systems not be left at that catchall CCSID 65535.
--
Jack Woehr, IBM Champion 2021
<
https://urldefense.com/v3/__https://www.youracclaim.com/badges/528d23d6-087f-4698-8d17-d59688106ac4/public_url__;!!JAIo9NhAvg!5Wx4SpqftHTkYR3HuRfc5KfypKL89hpLbjDa5pAzwa0M_0tdoNwxntrqzHFnlTXB$ > 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!5Wx4SpqftHTkYR3HuRfc5KfypKL89hpLbjDa5pAzwa0M_0tdoNwxntrqzKWW4gR6$
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!5Wx4SpqftHTkYR3HuRfc5KfypKL89hpLbjDa5pAzwa0M_0tdoNwxntrqzH3RYn9U$ .
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!5Wx4SpqftHTkYR3HuRfc5KfypKL89hpLbjDa5pAzwa0M_0tdoNwxntrqzGxJrpiq$
midrange.com
