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$

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.