Re: Codepage issue?

[Sarah Poger Gladstone <listmember@xxxxxxxxxxxxxx>]

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