Hello I came across a problem with nulls and SQL Server data types tinyint, smallint and int with J9.03 newest ODBC/Data Driver (Windows 10, SQL Server 2012/2019, ODBC Driver 17 for SQL Server) .
bigint is ok, also no problems in J9.02. Does anyone have similar problems with different scenarios? Best Regards, Esa *J9.03* require'dd' ]ch=.ddcon 'dsn=tes_info' 2411772141600 'create table #a(b int, c char(8))'ddsql ch 0 'insert #a values(1,''one'')'ddsql ch 0 'insert #a values(2,''two'')'ddsql ch 0 'insert #a values(null,null)'ddsql ch 0 ]sh=.'select * from #a'ddsel ch 2411772252304 ddfch sh,_1 ┌────────────────────┬────────┐ │ 1│one │ │ 2│two │ │_9223372036854775808│ │ └────────────────────┴────────┘ dddis ch 0 --- *J9.02* require'dd' ]ch=.ddcon 'dsn=tes_info' 2631811462080 'create table #a(b int, c char(8))'ddsql ch 0 'insert #a values(1,''one'')'ddsql ch 0 'insert #a values(2,''two'')'ddsql ch 0 'insert #a values(null,null)'ddsql ch 0 ]sh=.'select * from #a'ddsel ch 2631811463168 ddfch sh,_1 ┌──┬────────┐ │ 1│one │ │ 2│two │ │__│ │ └──┴────────┘ dddis ch 0 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
