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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.