David- Would it be possible to create an SQL view or logical file over
the physical file with the # in the field name? You could then put the
cleaned up field names in the view or logical.  Then write your select
statement to query the view or logical instead.

-Sarah Poger Gladstone

On 12/8/05, Larry Loen <lwloen@xxxxxxxxxx> wrote:
> 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
> --
> 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.