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

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