Re: SQL UDF From RPG Program

What error are you getting and when are you getting it?

The message was "GETZIPDIST in DMIPGMS type *N not found". I finally
managed to get when the function working via a service program call. My
problem was the literal value I was passing in my call to the function.

The following code doesn't work:

SELECT ZIPCODE FROM ZIPCENTER WHERE GETZIPDIST(ZIPCOD, '12345') <= 25

But this code DOES work:

SELECT ZIPCODE FROM ZIPCENTER WHERE GETZIPDIST(ZIPCOD, CHAR('12345')) <= 25

I haven't had much experience with SQL UDF's on IBM i, so maybe the
external UDFs won't play well with literal values. Using the CHAR function
isn't a big deal, but out of curiosity, is there a way to define the UDF so
the literal would be accepted without casting it?