Re: Codepage issue?

David Gibbs wrote:

>java.sql.SQLException: [SQL0113] Le nom TRJOB# n'est pas admis.
>Which translates into: Name TRJOB# not allowed.
>My gut says this is a code page or CCSID problem (the system is running
>in France).

>Is there a JDBC property I can set that will let me query that table
>without having to change the column name in the table?

I'm a bit at a loss.  Is the issue with the _contents_ of the field or the 
column name itself?

If it's the column name itself, why not just retreive it by number as per 
the JDBC interfaces?

The problem relates, almost certainly, to the trailing character known 
variously as the "pound sign" or "hashes" depending on who reads this. 
That's one of the so-called "national" characters in EBCDIC and it 
certainly can create problems in codepage translation.

Otherwise, DSPFFD will tell you what you need to know about the field's 
contents and definition, including its CCSID.


--

Larry Loen, Senior Programmer, iSeries i5/OS Scaling Analysis