RE: Selection a row using jdbc where a column containsembeddedblankson iSeries.

Apologies my mistake, it should be '6E12  BYD3' and not '6E12
BYD30'. It was a typo.

Rajesh Anand
Email:Rajesh_anand@xxxxxx


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Clapham, Paul
Sent: 16 May 2006 15:59
To: Java Programming on and around the iSeries / AS400
Subject: RE: Selection a row using jdbc where a column
containsembeddedblankson iSeries.


The constant you are comparing to has 11 characters so it could not
possibly match anything in a 10-character column.

PC2 

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Anand, Rajesh
Sent: May 16, 2006 07:48
To: Java Programming on and around the iSeries / AS400
Subject: RE: Selection a row using jdbc where a column contains
embeddedblankson iSeries.

        It works fine on iSeries SQL interactive session but doesn't
work from Java app.

        And I get...

        SELECT firm,office, acct FROM Table WHERE ref = '6E12  BYD30'.

        Incidentally, the database file has field ref as 10 char long
and not varchar.