Re: SQL date comparison - a better way?

Yes, isn't that frustrating?

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





Raul A Jager <raul@xxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
08/14/2003 12:41 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        Re: SQL date comparison - a better way?


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.
> 
>

_______________________________________________
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.