I have created a UDF to return a scalar function within an SQL Select statement. The UDF references a procedure within a service program. The Select works fine when using SQL on the IBM i - Run SQL Scripts from Navigator, Run SQL Scripts from ACS (is that the same?), and green-screen STRSQL. But when I try to reference it from within Excel, using "Get external data" / "From other sources" / "From Microsoft Query", I get "SQL0204 - XX0504V in OELIB type *SRVPGM not found" (where XX0504V is in fact the name of the service program).

I have learned that the SQL0204 "not found" message can really mean something like parameter mismatch, so I have checked and tinkered with those to no avail. The connection defined in Excel has the same user ID and the same library list, plus the UDF name is qualified; I see no reason that it can't really be found. I suspect either a difference in syntax between the two SQL's (MS and IBM i) or something else relating to the connection definition. All other SQL which I have copied over in this way works fine; it seems to be only the UDF.

(I'm new on this list so forgive me if this has been addressed before; I was not able to find anything in the history.)

Thanks for any direction.

Bill Reed

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.