Re: SQL select question

 C/exec sql
 C+ Declare C1 cursor for
 C+ Select *
 C+ from REVENUE
 C+ WHERE REMKRE = :MKMOD2 and
 C+        CONCAT(CHAR(REYR4) + CHAR(REMONT) + CHAR(REDAY))
 C+        BETWEEN :sdate AND :edate
 C+ order by REYR4, REMONT, REDAY, REMKRE
 C/end-exec


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    Lori Crane
                    <lcrane@emedco.co        To:     rpg400-l@midrange.com
                    m>                       cc:
                    Sent by:                 Subject:     SQL select question
                    rpg400-l-admin@mi
                    drange.com


                    04/10/02 11:36 AM
                    Please respond to
                    rpg400-l






Can anyone help me out?  I am trying to select data from a Revenue file
based on the date range the user keys in.  It can be many ranges for dates.
The file has a YYYY MM DD fields(REYR4, REMONT, REDAY).  How can I combine
all date fields in Revenue file and make on 8 0 S date field for comparing
what the user keys in?  I tryed a data structure unsuccessfully.

 **-*-*-*-*
 C/exec sql
 C+ Declare C1 cursor for
 C+ Select *
 C+ from REVENUE
 C+ WHERE REMKRE = :MKMOD2 and
 C+        (REYR4 + REMONT + REDAY)  >= :SDATE   and

 C+        (REYR4 + REMONT + REDAY)  <= :EDATE
 C+ order by REYR4, REMONT, REDAY, REMKRE
 C/end-exec
 **-*-*-*-*
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.