RE: SQL and RPG Parameter Handling

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

I'm not Matt, but... 

I would agree if it weren't for the fact that UDF interfaces use service
programs and modules.  The fact that *PGM objects are called only by
reference, is immaterial.  

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"The most remarkable thing about my mother is that for thirty years she
served the family nothing but leftovers.  The original meal has never been
found."
        -- Calvin Trillin 


> I am pretty sure that "PARAMETER STYLE GENERAL" means that each
> parameter is passed "by reference", which is the usual convention when
> CALLing an external *PGM in OS/400. That is to say, since this is an
> "external" UDF, you can pass parameters by reference, but not by value.
>
> Does that help?
>
> Mark S. Waterbury
>
>  > On 7/30/2010 4:30 PM, MattLavinder@xxxxxxxxxxxxxxxxxxx wrote:
> > > Not sure why you feel this would require you to "always change the
> > > prototype."  Seems to me (what works for me is) that for UDF and
> stored
> > > procedures, my prototypes say CONST instead of VALUE.  What problem
> does
> > > this create for you?
> > Basically I was asking, "Am I doing this wrong or is this the only
> way to
> > fix it?"  It's not difficult, but if I was defining the UDF
> incorrectly,
> > correcting that definition would be a simpler solution.