Re: Embedded SQL (right subject this time)

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

LOL - you never know - we might actually have some new RPG developers 
showing up!!

:-)

On 8/3/2010 11:06 PM, Alan Campin wrote:
> 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