[unixODBC-support] db2 null values

LocoJay Dev locojaydev at gmail.com
Wed Feb 22 00:47:48 GMT 2012


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')

select * from test.unixodbc should return
	a, b
	  , d 

but i get
	a, b

here 's a pic: 

vs another sql client:


i m using isql --version :

unixODBC 2.3.1

uname -a :
Darwin locojaymp.local 11.3.0 Darwin Kernel Version 11.3.0: Thu Jan 12 18:47:41 
PST 2012; root:xnu-1699.24.23~1/RELEASE_X86_64 x86_64 

db is DB2 odbcinst.ini:
Description = IBM DB2 Adapter
Driver      = /Users/locojay/sqllib/lib/libdb2.dylib
FileUsage   = 1
DontDlClose = 1

here's the gist of the sql.log:


Is there a config i have to set? it s not a display error as i do get the wrong values when using pyodbc as well.

Thanks for helping

More information about the unixODBC-support mailing list