[unixODBC-support] db2 null row bug

LocoJay Dev locojaydev at gmail.com
Thu Aug 11 20:20:31 BST 2011


the db2 client does not do the same. (typo in previous mail)
db2 'select id,name from test.test where id=1'  gives
1,NULL
On Aug 11, 2011, at 3:00 PM, Nick Gorham wrote:

> On 11/08/2011 19:41, Loco Jay wrote:
>> hi i m using db2
>> 
>> when id do a query with isql on a row which contains null values
>> eg
>> 
>> select id,name from test.test where id=1
>> 
>> expected is
>> 	1,NULL
>> i get
>> 	1,1
>> 
>> any idea?
>> 
>> using db2 client too , razorsql gives the correct result.
> 
> Not sure. Have you asked the db2 folk? If db2 client does same it looks like a driver issue.
> 
> -- 
> Nick



More information about the unixODBC-support mailing list