RE: Conditional Select in SQL

[Alan Shore <AlanShore@xxxxxxxx>]

My aplogies Kent.
It must be because its a long day. Now that you re-wrote your question, I
realized that I had mis-read your initial question.

Alan

rpg400-l-bounces@xxxxxxxxxxxx wrote on 11/07/2006 04:24:32 PM:

> Something like:
>
> Select * from table
> Where CHGDTE = InputDate or
>       (CHGDTE = 0 and ENTDTE = InputDate)
>
>
> |-----Original Message-----
> |From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> |On Behalf Of Alan Shore
> |Sent: Tuesday, November 07, 2006 4:21 PM
> |To: RPG programming on the AS400 / iSeries
> |Subject: Re: Conditional Select in SQL
> |
> |I'm sorry Kent, maybe its just that its at the end of a long day, but
> what
> |you wrote just didn't make much sense.
> |My interpretation of your description is as follows:-
> |
> |The table (file) contains a field called change date (CHGDTE for
> example)
> |You want to select rows when the entered date (DATEIN) is equal to the
> |change date (CHGDTE)
> |unless, the change date (CHGDTE) is 0, in which case you want to select
> |rows when the entered date (DATEIN) is equal to the change date
> (CHGDTE).
> |
> |Like I said - end of a long day
> |
> |
> |
> |Alan Shore
> |
> |NBTY, Inc
> |(631) 244-2000 ext. 5019
> |AShore@xxxxxxxx
> |
> |rpg400-l-bounces@xxxxxxxxxxxx wrote on 11/07/2006 04:02:18 PM:
> |
> |> Can someone tell me how I would do the following?  I want to create
> an
> |> embedded SQL statement that will select rows when the change date in
> a
> |table
> |> meets a certain date.  But, the issue is the change date may be zero.
> If
> |> the change date is zero, I want to select rows where the entered date
> |meets
> |> a certain date.  I need all these selected in one group so I can sort
> |them
> |> as a group.
> |>
> |> Any help would be appreciated.
> |> Kent Hohlen
> |> Eagle Window & Door
> |> PO Box 1072
> |> 2045 Kerper Blvd
> |> Dubuque  IA  52004-1072
> |>
> |> --
> |> This is the RPG programming on the AS400 / iSeries (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.
> |>
> |--
> |This is the RPG programming on the AS400 / iSeries (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.
>
>
> --
> This is the RPG programming on the AS400 / iSeries (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.