I have an SQL statement I'm trying to turn into a table user defined
function (ie. a UDF that returns a table).

However, this SQL statement uses Common table expressions via the "with
TmpTable as (select ...)"

Which the create function doesn't seem to like.

I've tried replacing the CTE with a "Declare Global Temporary Table TmpTable
as (select ...) with data"

But, I get an error trying to run the create procedure:
SQL0577 - Modifying SQL data not permitted.

I added the "reads SQL data" statement to the UDF, but it doesn't seem to
have helped.  I do not modify any data in this statement.

Anybody know how I need to do this?


As an Amazon Associate we earn from qualifying purchases.

This thread ...

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

This mailing list archive is Copyright 1997-2022 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.