topic ERROR: CLI open cursor error: [IBM][System i Access ODBC Driver][DB2 for i5/OS]PWS9801 in SAS Enterprise Guide

ERROR: CLI open cursor error: [IBM][System i Access ODBC Driver][DB2 for i5/OS]PWS9801

ScorpioAA — Sun, 11 Dec 2022 12:16:17 GMT

Hello,

I'm doing a Proc SQL to access a library and getting the following error

ERROR: CLI open cursor error: [IBM][System i Access ODBC Driver][DB2 for i5/OS]PWS9801 - Function rejected by user exit program
PTNS0107 in QGPL.

any help is greatly appreciated

Re: ERROR: CLI open cursor error: [IBM][System i Access ODBC Driver][DB2 for i5/OS]PWS9801

ger15xxhcker — Sun, 11 Dec 2022 14:12:19 GMT

The most likely cause of this error is that the user exit program that was specified in the ODBC configuration is not available in the QGPL library. User exit programs are usually configured to check a specific library to see if the program exists. You can fix this by either ensuring that the program exists in QGPL or by configuring the ODBC configuration to look in the correct library.