MIDRANGE dot COM Mailing List Archive



Home » JAVA400-L » May 2006

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



fixed

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.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact