Re: SQL date comparison - a better way?

[Raul A Jager <raul@xxxxxxxxxx>]

The "not found" message may be misleading, if you call your procedure 
with the wrong parametres it will also give the "not found"

Chevalier, Rick wrote:

> Rob,
>
> I have written a simple UDF to try this out.  I'll expand the functionality
> once I get it to work.  Currently SQL can't find the function.  I followed
> the steps in the SQL Programming Concepts, SQL Reference, and FAQ articles.
> I must have missed something somewhere though.  
>
> I get this message when I try to use the function:  CVTDTEUF in *LIBL type
> *N not found.
>
> I created the function like this:  
> create function rcheva1/cvtdteuf (dec(8,0), char(5), char(5))
> returns char(10) language rpgle Deterministic no sql         
> returns null on null input No external action allow parallel 
> simple call external name 'RCHEVA1/CVTDTE(CVTDTEUF)'         
> CREATE FUNCTION statement complete.                          
>
> My library is in the library list.
>
> Any hints would be appreciated.
>
> Rick
>
> -----Original Message-----
> From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
> Sent: Tuesday, August 12, 2003 3:16 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: SQL date comparison - a better way?
>
> Exactly!  There is an excellent faq on these:
> http://faq.midrange.com/index.pl?_highlightWords=udf&file=185
>
> Rob Berendt
> --
> "They that can give up essential liberty to obtain a little temporary
> safety deserve neither liberty nor safety."
> Benjamin Franklin
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>