Input tool bringing back half of the records as nulls

Hi,

I have a workflow that connects to a Db2 environment (odbc driver version 11.05.00.1077). The issue is that while all expected rows are returned, only 50% of the rows are returned with values. For example, in below scenario i expect 8 fully populated records, and can show the same query result when run using sql dev. IDE. In Alteryx 4/8 rows are populated while the remaining 4, while present, return with nulls for every column.