Re: SQL UDF in RPG (PDQ?)

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

On 4/20/2011 6:56 PM, James Lampert wrote:
> Question: Now that the UDF is registered on this ILE RPG SRVPGM, what
> happens if I have to modify the SRVPGM? Do I have to DROP and reCREATE
> the UDF and the VIEW?

No.

But, if the *SRVPGM is still activated after you change it, you'll need 
to end any activation groups that have already loaded it.  (If you're 
running it through Run SQL Scripts, simply closing/opening the Run SQL 
Scripts window seems to take care of that.)

But, no, unless you change the parameters, object name, or something 
else that's coded in the Create Function statement, you shouldn't have 
to drop/create.