Re: [Jprogramming] Integer data type null problem in J9.03 data driver

2022-09-03 Thread esal
Thank you Bill for the information! Best Regards, Esa On Sat, Sep 3, 2022 at 4:42 PM bill lam wrote: > Hi Esa, > the integer null in j904 have been changed to IMIN (the integer you > noticed) so that the data type will not promote to floating point when > there are null values in the data. > Y

Re: [Jprogramming] Integer data type null problem in J9.03 data driver

2022-09-03 Thread bill lam
Hi Esa, the integer null in j904 have been changed to IMIN (the integer you noticed) so that the data type will not promote to floating point when there are null values in the data. You can change the representation of null or restore it to j903 using the ddconfig command, specifically, putting thi

[Jprogramming] Integer data type null problem in J9.03 data driver

2022-09-02 Thread Pawel Jakubas
Hi Esa, I come across the same behavior when experimenting using j903 with 1. 'data/sqlite' (details with example here https://github.com/paweljakubas/j-data-analysis/blob/main/chapters/sql.md) 2. 'jd' (details with example here https://github.com/paweljakubas/j-data-analysis/blob/main/chapters/cs

[Jprogramming] Integer data type null problem in J9.03 data driver

2022-09-02 Thread esal
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 scenario