Re: Access UDTF from MS SQL Server

Multiple copies floating around?

One thing I would question is why you are using the Microsoft OBDC driver
instead of the IBM IBMDA400 driver. We had all kinds of problems with the
Microsoft one until I switched everything to the IBM OLE DB Driver. That
might be what is causing the problem.

On Thu, Sep 15, 2011 at 1:44 PM, Lorne Sturgeoff <
lorne.sturgeoff@xxxxxxxxxxx> wrote:

I have created a User Defined Table Function (UDTF). When accessed from
from
iNavigator it works well. We want to access the UDTF from MS SQL using
openquery but when we do we get the following message,

OLE DB provider "MSDASQL" for linked server "myServer" returned message
"[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0551 - Not authorized to
object myServicePgm in myLibr type *PGM.".
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "myServer" reported an
error. The provider indicates that the user did not have the permission to
perform the operation.
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "select * from table(myLibr.myUDTF('xxxx')) as t"
against OLE DB provider "MSDASQL" for linked server "myServer".

The interesting thing is that it found the service program which is
associated with the UDTF, myServicePgm, (although the error erroneously
states that it is type *PGM instead of type *SRVPGM). The service program
has *PUBLIC *USE authority so I cannot understand why this error message
would be coming back.

Can anyone offer any insight?

Cheers,
Lorne.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.