Re: Character conversion between CCSID 1200 and CCSID 65535 not valid.

Justin, from this example try and code it.

SELECT emidnm, emfnam, CAST(emlnam AS CHAR(20) CCSID 37)



On Thu, Nov 17, 2016 at 2:30 PM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

I have an SQLRPGLE programs that's getting this message:
SQL0332 Character conversion between CCSID 1200 and CCSID 65535 not valid.

Here's the SQL:
select coalesce(COLUMN_TEXT, COLUMN_HEADING, '') as COLUMN_TEXT
from QSYS2.SYSCOLUMNS


My job CCSID is 37, but when I do a DSPSRVPGM, the second page shows
65535. I looked for a compile setting, but I can't find one. Anyone know
how to get around this?


Thanks
Justin Taylor

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.