RE: Character conversion between CCSID 13488 and CCSID 65535 not valid

["Xu, Weining" <Weining.Xu@xxxxxxx>]

Jim,

Thanks for your help!  In my case, after I use: CHGJOB CCSID(37) before
running Java Stored Procedure, the error is gone. 

Wayne

-----Original Message-----
From: Bruce Jin [mailto:JIN007M@hotmail.com]
Sent: Tuesday, January 28, 2003 7:19 PM
To: Java Programming on and around the iSeries / AS400
Subject: Re: Character conversion between CCSID 13488 and CCSID 65535
not valid


Thanks Wayne for the info:



According ibm native driver faq
http://www-919.ibm.com/developer/jdbc/Faqs/JDBCFAQ.html#B15, this problem
may be fixed using the listed methods. I tried and they did not work.

In my case, file update only fails when the string that is used to update
the a column contains packed data. It works if the string contains alpha
characters only.



And it always works if I use jt400 on  PC.



I also tried to change the ccsid of my file using:



ALTER TABLE MYLIB/MYFILE ALTER COLUMN PFX   SET DATA TYPE GRAPHIC (850)
CCSID 13488



But the command fails with: "SQL system error".



Thanks.



----- Original Message -----
From: "Xu, Weining" <Weining.Xu@AIG.com>
To: "'Java Programming on and around the iSeries / AS400'"
<java400-l@midrange.com>
Sent: Tuesday, January 28, 2003 12:39 PM
Subject: RE: Character conversion between CCSID 13488 and CCSID 65535 not
valid


> I had the similar problem when I run a Java stored procedure on AS/400 by
> using native JDBC driver.  I got the error message:
>
> com.ibm.db2.jdbc.app.DB2DBException: Character conversion between CCSID
> 65535 and CCSID 13488 not valid.
>
> And the same code runs OK on PC with jt400.jar.
>
> I still don't have any answer yet.
>
> -----Original Message-----
> From: Bruce Jin [mailto:JIN007M@hotmail.com]
> Sent: Tuesday, January 28, 2003 5:50 PM
> To: java400-j
> Subject: Character conversion between CCSID 13488 and CCSID 65535 not
> valid
>
>
> I have a character field that is 400 in length.  When this field contains
> packed data (which I get by calling a RPG program), update file using
native
> driver fails with following error:
>
>
>
> com.ibm.db2.jdbc.app.DB2DBException: Character conversion between CCSID
> 13488 and CCSID 65535 not valid.
>
>
>
> If this field does not contain packed data, update file is OK.
>
> Also, the same code runs OK with remote database update (using jt400),
> regardless this field contains packed data or not.
>
>
>
> Is this a bug in as400 native driver?
>
>
>
> Thanks!
>
>
>
> Bruce
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.