Re: CCSID 65535 and JDBC Connection

Hi
Setting the user with CCSID 65535 is a problem, as IBM does not support JDBC connection with CCSID 65535 on V5R3 and above,
The problem i am having is on Japan AS400, where they have files with CCSID 65535 and jobs running under 5026.
Is there any work around you can think of?

Regards
A$HI$H


--- On Wed, 7/9/08, David Gibbs <david@xxxxxxxxxxxx> wrote:

From: David Gibbs <david@xxxxxxxxxxxx>
Subject: Re: CCSID 65535 and JDBC Connection
To: "Java Programming on and around the iSeries / AS400" <java400-l@xxxxxxxxxxxx>
Date: Wednesday, July 9, 2008, 4:51 PM
Ashish Kulkarni wrote:

Does CCSID 65535 cause issue when reading data from

AS400 file,

The CCSID itself doesn't cause a problem ... IIRC,
CCSID 65535 means "No
Translation". Data read from the file will be
returned exactly as it's
stored. No transcoding from the database CCSID to the job
CCSID (not
sure if transcoding is the right word).

Is there a way to read proper data from this file

using JDBC

connection without changing CCSID of this file

Make sure the user profile you are using to connect to the
host has the
same CCSID as the data in the file.

david

--
IBM System i - For when you can't afford to be out of
business

--
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.