java400-l-bounces@xxxxxxxxxxxx wrote on 12/08/2005 10:22:51 AM:

> Mark Phippard wrote:
> >>I've got a JDBC statement that is getting the following error ...
> >>java.sql.SQLException: [SQL0113] Le nom TRJOB# n'est pas admis.
> >>Which translates into: Name TRJOB# not allowed.
> > To solve the problem I created a table that was keyed by an integer 
and 
> > had a 1-char field with CCSID 65535.  I then added rows for a bunch of 

> > special characters.  I then made a small Java class that will query 
this 
> > file and return the character. 
> 
> Unfortunately, changing the table is not really an option for me.
> 
> Since the column is clearly valid in the database, I need to figure out
> a way to make JDBC use a ccsid that will handle the table correctly.

I didn't say anything about changing the table.  I was in the same boat as 
you, and I told you the way to do what you are asking. 

Read it again.

Mark


_____________________________________________________________________________
Scanned for SoftLanding Systems, Inc. and SoftLanding Europe Plc by IBM Email 
Security Management Services powered by MessageLabs. 
_____________________________________________________________________________

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

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