RE: MIDRANGE-L Digest, Vol 5, Issue 634

I agree with Rob....cast everything in your SQL select to the exact type
and length the function is looking for even if it's already that type
and length.

If that does not work , try changing your in_company character( 3 )) to
a varchar and again cast.   I seem to have better luck with varchar.

Yes...you can call a RPGLE program.   

David Smith
IT Consultant
Tri-State Hospital Supply Corporation
(517) 546-5400  Ext. 1359 

>>from: rob@xxxxxxxxx
>>subject: RE: SQL Select Statement in a Stored Procedure Question - Got
>>      Futher  - But....
>>
>>UDF's support "overloading".  Meaning you can have the same UDF name
in
>>the same library multiple times.  They just have different parameter
>>styles.
>>
>>So, when you get the message that the UDF was not found, what it was
>>really saying was that it couldn't find a UDF with those exact
parameters.
>> You might want to try a liberal sprinkling of CAST all over the
place.
>>
>>On the RPGLE, I don't think you can create a UDF to call a RPGLE
program.
>>I think it has to call a subprocedure in a service program.  Look
again at
>>the sample I provided in that FAQ.
>>
>>Rob Berendt