By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,850 Members | 1,771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,850 IT Pros & Developers. It's quick & easy.

use dynamic SQL in external user-defined table function

P: n/a
mm
Hi,

Is it true that we can use dynamic SQLs in external user-defined scalar
functions but not in table functions?

I saw an example of "dynamic SQL in an external scalar function" in a
sample file coming with DB2 (the Convert() function in the file
sqllib/samples/c/udfemsrv.sqc).

I tried to write a table function in C which executes dynamic SQLs to
return a subset of a table, but I kept receiving an error message
(SQL0443N) with the sqlcode = -519. This error occurred during the
"PREPARE" statement.

Anyone has ideas? Thanks a lot!

-MM

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.