Re: Creating an SQL UDF on a procedure

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

Hi Alan,

I learned about this a long time ago, not sure exactly how.  I _think_ 
it's all documented in the SQL Reference manual.

There's not much to it, though:

1) Use DB2SQL parameter style.
2) Add the optional CallType parameter (10i 0 in RPG)
3) Check it, and run your code as appropriate.



On 3/15/2012 12:55 PM, Alan Shore wrote:
> This sounds exactly what would be required in this instance.
>
> I am in the middle of doing something else at the moment, so I
> haven't researched what you mentioned, but any idea where I could
> find some information on what you are talking about?