RE: SQL date comparison - a better way?

We ran into the same issues here with a couple of UDFs. Try using the CHAR()
function in SQL to specify your character fields. Like this:

cvtdte(fieldname, char('*MDY ', 5), char('*ISO ',5))

I believe it has to do with the fact that SQL sees the charcter values
you're passing as variable length fields and your UDF is expecting Char(5)
fields. But, that's just a guess on my part :).

-Kevin
Kevin R Mohondro
Programmer/Analyst
Ashworth, Inc.


> -----Original Message-----
> From: Chevalier, Rick [mailto:Rick.Chevalier@xxxxxxxxxxxxxxx] 
> Sent: Thursday, August 14, 2003 1:56 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: SQL date comparison - a better way?
> 
> 
> Rob,
> 
> How did you resolve the constants issue?  I think that's what 
> is getting me. I finally got it to work with a definition of 
> 1 parm dec(8,0).
> 
> What I really want is cvtdte (dec(8,0), char(5), char(5)).... 
>  That way I can call it like this cvtdte(fieldname, '*MDY', 
> '*ISO').  When I add the second and third parms I get the not 
> found message again.
> 
> Rick
> 
> -----Original Message-----
> From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
> Sent: Thursday, August 14, 2003 1:50 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: SQL date comparison - a better way?
> 
> Exact parameter matching is important, and not just the 
> number of parameters.  I always had a bear of a time trying 
> to use these by passing in constants.  You know, like Select 
> filename.fld1, MyUdf('A',filename.fld2) from mylib/myfile filename
> 
> 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.
#####################################################################################