Re: Embedded SQL (right subject this time)

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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
>
> This message, including its attachments, constitutes an electronic
> communication within the meaning of the Electronic Communications Privacy
> Act, 18 U.S.C. Section 2510.  This message is the confidential property of
> RockTenn, and disclosure is strictly limited to recipients intended by the
> sender.  Unless previously authorized in writing, this message does not
> constitute an offer, acceptance, or agreement of any kind.  This message may
> contain confidential attorney-client privileged information and attorney
> work product.  If you are not the intended recipient, or responsible for
> delivering e-mail to the intended recipient, you are advised that use,
> dissemination, forwarding, printing, or copying of this message is STRICTLY
> PROHIBITED.  If you receive this message in error, please notify the sender
> immediately by return e-mail and delete the message entirely from your
> system.  Sender is not liable for damage caused by viruses transmitted with
> this message, or errors or omissi!
>  ons in content caused by transmission.
> (c) RockTenn, Norcross, GA.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.