[unixODBC-support] db2 null values

Loco Jay locojaydev at gmail.com
Thu Feb 23 16:35:26 GMT 2012


build is 64 bit and libdb2 as well.
how can i check the sizeof(SQLLEN)

thanks

On Feb 22, 2012, at 3:11 AM, Nick Gorham wrote:

> On 22/02/2012 00:47, LocoJay Dev wrote:
>> Hi
>> 
>> when doing query on tables including null values i do not get these returned correctly.
>> 
>> for example
>> 
>> create table test.unixodbc(col1 varchar(2), col2 varchar(2))
>> insert into test.unixodbc(col1,col2) values('a', 'b')
>> insert into test.unixodbc(col1) values('c')
>> insert into test.unixodbc(col2) values('d')
> 
> I would say its possibly down to a driver problem, unixODBC just passes the indicator value back from SQLGetData.
> 
> If the build is 64 bit, I would check if the sizeof( SQLLEN ) is the same with the driver manager, tools and apps and the driver.
> 
> -- 
> Nick
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support



More information about the unixODBC-support mailing list