RE: SQL and EBCDIC Convert ...

This advice is good for the American system - CCSID 37 is US English.
If you are not in the USA and your data is using different codepage, you 
should use the correct CCSID for your data.

    Alexei Pytel

Where is the beginning of the end, which ends the beginning?



"Urbanek, Marty" <Marty_Urbanek@xxxxxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
03/21/2004 02:29 PM
Please respond to
Java Programming on and around the iSeries / AS400 


To
"'java400-l@xxxxxxxxxxxx'" <java400-l@xxxxxxxxxxxx>
cc

Subject
RE: SQL and EBCDIC Convert ...






If Colin's response didn't get you going, I suggest that the problem with
your CCSID error is because your machine and job are using CCSID 65535. If
you want to use GRAPHIC stuff, try doing CHGJOB CCSID(37) before you start
doing your SQL stuff.

-Marty
 
------------------------------

date: Sun, 21 Mar 2004 14:55:38 +0100
from: Peter.Daransky@xxxxxxxx
subject: SQL and EBCDIC Convert ...

Hi *All, 
... again question about SQL and converting from EBCDIC to UTF ... 
I've now problem that i need "dynamic" convert EDCDIC string to UTF, so i 
mean sometime yes and sometime not. 
I've found here in Archiv something about GRAPHIC() SQL function, i've 
tryed it but it doesn't work for me (i got error, that conversion between 
65535 and 13488 ist invalid)? 

Any idea ? 

Peter 
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.