RE: UDF problems in STRSQL

["Mackie, Roger L. (Precision Press)" <RLMackie@xxxxxxxxxxxxx>]

In my experimentation, CAST does not affect results. I still get the
selection error on the production file. On the test file (without
DATFMT(*USA) on the field names), I do not get any errors and still do
not get the expected result set no matter what the DATFMT is in the
STRSQL session. I even tried converting the date to character before
casting it back to date with the same results.

Thanks for the suggestion,
Roger Mackie

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mackie, Roger L.
(Precision Press)
Sent: Thursday, May 05, 2005 16:38
To: Midrange Systems Technical Discussion
Subject: RE: UDF problems in STRSQL

Interesting thought. I don't know that much about CAST and didn't find a
way to use it to specify a date format attribute in the manuals, but I
was only skimming. Tomorrow is another day...

Thanks,
Roger Mackie

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, May 05, 2005 15:53
To: Midrange Systems Technical Discussion
Subject: Re: UDF problems in STRSQL

Any way to

SELECT * FROM MYFILE WHERE INVYR = 2005 and INVNO = 6557 and
CLCDAYSHPLAT(cast(ODDDAT as ...

Rob Berendt
<snip>