topic Re: [POC_Chinalife] SQL0501 - Cursor SQL_CURD96049B0 not open. in Qlik Replicate

SQL0501 - Cursor SQL_CURD96049B0 not open.

Aaron_Liu — Mon, 20 Dec 2021 09:21:21 GMT

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

Re: [POC_Chinalife] SQL0501 - Cursor SQL_CURD96049B0 not open.

john_wang — Mon, 20 Dec 2021 09:10:41 GMT

Dear Aaron,

I'm trying to reach out to you now, I'd like to share something to you.

Regards,

John.

Re: [POC_Chinalife] SQL0501 - Cursor SQL_CURD96049B0 not open.

john_wang — Mon, 20 Dec 2021 10:38:12 GMT

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.