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?


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


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

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.