Calling a query with a user define function UDF

[JBaileys]

Within a function, a query is built which can be quite complex. The query is a varchar which is manipulated by the function.

What is the syntax to execute the query? The result set is functions return (returns a table).


Thanks,

JB

 

[sathyarams]

You may need a stored procedure

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp

 

[JBaileys]

I have tried multiple attempts. In one attempt, I do call a stored procedure and received an error SQL0746N routine ... violated nested sql statement rules when attempting to perform operation "modify" on table ... sqlstate = 57053

 

[sathyarams]

Did you look up for the message in the Message Reference ?

Is there a sample piece of code to demonstrate what you are trying to achieve?

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp