Hello friends,
I am having a slight problem firing queries to an AS400 table containing a date field. Now all I am doing is
rs.executeQuery(Select avbirthdt from AW@lib2.aw@P333 where avfname='john' and avlname='smith');
Now the resultset is retrieved this way
if(rs.next())
System.out.println(rs.getString(1));
And it prinnts 'null', whereas the table has the value 10/08/1927 stored in it.
Also, this seems to work for certain people. But for the major chunk it doesnt. Any ideas?
Thanks,
Ashwin
I am having a slight problem firing queries to an AS400 table containing a date field. Now all I am doing is
rs.executeQuery(Select avbirthdt from AW@lib2.aw@P333 where avfname='john' and avlname='smith');
Now the resultset is retrieved this way
if(rs.next())
System.out.println(rs.getString(1));
And it prinnts 'null', whereas the table has the value 10/08/1927 stored in it.
Also, this seems to work for certain people. But for the major chunk it doesnt. Any ideas?
Thanks,
Ashwin
Comment