we are running migration and compatibility tests from power builder version 9 to 2019 version of a 2-tier application developed 15 years ago.
The application was developed in PB 9.0.1 Build 6533.
We are now testing the same application under PB 2019 R3 build 2728.
Here is the problem, a database query is performed from a datawindow. The query works fine in PB9 but
the same query raises the following error in PB2019R3 "Select Error: SQLSTATE = S1010
[Microsoft] [ODBC Driver Manager] Error in function sequence. "
The application retrieves only a part of the records, on PB9 it retrieves 165 records without errors while on PB2019 it retrieves 140 records raising the error.
Soon after, whatever action is performed on the application causes it to crash.
We are using an ODBC 32-bit connection (in a 64 bit environment) to IBM DB2 database DB2 v18.104.22.1687.
The odbc driver number is : "DB2 v22.214.171.1247 - 11.01.00.1527 - DB2CLI.DLL 10/06/2016".
We do not know if the problem occurs on other datawindows, because we should check them all to know.
Everything works fine on others DW but on this one it doesn't.
Any idea on the this problem?