RE: SQL date comparison - a better way?

["Chevalier, Rick" <Rick.Chevalier@xxxxxxxxxxxxxxx>]

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