Re: Access UDTF from MS SQL Server

[Alan Campin <alan0307d@xxxxxxxxx>]

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.