This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have connected to our IBMi Access ODBC Driver for JDE Edwards using the input tool and I am able to access any World Writers/Queries created in the standard library using the select table option however I want to access the actual underlying tables to access the real time directly. I am assuming I could do this via the SQL editor but when trying to enter I get the error "Error SQL Prepare: [IBM] System i Access ODBC Driver][DB2 for i5/os]PWS9801 - Function rejected by user exit program SAFENET in PCSECLIB."
Here is what I entered into the SQL Editor
Select ABAN8 from GFGO.JCFSCAP1. F0101
JCFSCAP1 is the library and F0101 is the file/table.
I am assuming because I can access the query data without issue I have the driver settings correct and I am just entered into the SQL editor incorrectly?
I don't know if you checked this or not, but in my experience with IBM products (particularly i series) I only recall seeing this error type when there is a program blocking people without certain access to certain files. Like lets say that you have a file with SSN info on there and because of your SOX regulations, only certain folks are allowed to see what is in there.
I imagine that you are okay when looking at a logical table, but the source table is blocked?
If I am correct, you will need to go to you iSeries admin for access to the raw file, or worst case scenario, have them create a real time logical file that nulls out whatever protected values exist in that file.