RE: SQL date comparison - a better way?

Try the create function again but, remove the RCHEVA1 off of the function
name on the first line. When placed in that location, SQL sees it as a
schema not a library. It should remain on the external name.

BTW, you can see any of your registered UDFs by querying the QSYS2/SYSFUNCS
file.

-Kevin

Kevin R Mohondro
Programmer/Analyst
Ashworth, Inc.

> -----Original Message-----
> From: Chevalier, Rick [mailto:Rick.Chevalier@xxxxxxxxxxxxxxx] 
> Sent: Thursday, August 14, 2003 9:22 AM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: SQL date comparison - a better way?
> 
> 
> 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

#####################################################################################
Attention:
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material.  Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the sender and
delete the material from any system and destroy any copies.

Thank You.
#####################################################################################