Re: Embedded SQL (right subject this time)

i have given it so many times you would think it is seared into everyone's
memory.

www.think400.dk/downloads.htm



On Tue, Aug 3, 2010 at 6:08 PM, Vern Hamberg<vhamberg@xxxxxxxxxxx> wrote:

Alan

It might help to provide the URL for your site, where he can get iDate.
Maybe not everyone knows it's a free user-defined function you've put
together.

Vern

On 8/3/2010 4:39 PM, Alan Campin wrote:

If you are using iDate, it will return a null if the date is invalid.

On Tue, Aug 3, 2010 at 2:49 PM, Luis Rodriguez<luisro58@xxxxxxxxx>

wrote:

Arthur,

COALESCE checks only against a NULL value. You could use an UDF that

checks

if your date is valid or not.

Regards,


Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Tue, Aug 3, 2010 at 4:07 PM, Arthur Marino<amarino@xxxxxxxxxxxx>
wrote:

Hi All,

I've defined a simple cursor that does a date range selection on an
mmddyy date in a file (it's coded to convert it to a true date field
before the test). It ran fine (no halts) but had fewer records than it
should have because it aborted on an invalid date it found (023004). I
tried COALESCE to no avail.

How do you tell SQLRPGLE to ignore a selection error? (There has to be

a

way, right?)

Thanks.

Arthur J. Marino
RockTenn Corporation
(631) 297-2276