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

[ScorpioAA]

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 

[ger15xxhcker]

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.