Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Sirs,
Is it the DB2 iSeries V7R2 version patch will effect the task working?
We are in the POC stage , user's db2 v7r2 patch is 19123 , and they install the db2 ODBC driver version: '07.01.011' , and we used QR two version one is the V2021_05 other is the 7.0.0.213 but both got same error message '[SOURCE_UNLOAD ]E: RetCode: SQL_ERROR SqlState: 07005 NativeError: -501 Message: [IBM][System i Access ODBC 驅動程式][DB2 for i5/OS]SQL0501 - Cursor SQL_CURD96049B0 not open. [1022502] (ar_odbc_stmt.c:3360)'
Please tell us how to solve this issue?
Thanks.
Aaron 2021-12-20
Dear @Aaron_Liu ,
By default Replicate use "prefetch=1". You can disable it in the ODBC DSN, as below:
Let me know if it helps.
Regards,
John.
Dear Aaron,
I'm trying to reach out to you now, I'd like to share something to you.
Regards,
John.
Dear @Aaron_Liu ,
By default Replicate use "prefetch=1". You can disable it in the ODBC DSN, as below:
Let me know if it helps.
Regards,
John.