RE: RPGILESQL PGM

["Kevin Monahan" <kevin.monahan@xxxxxxxxxxx>]

Also, as someone pointed out in an earlier post, comparing the
days will cause problems.  If you want all records between
August 1 and September 3, and you compare the days, you will miss
all records greater than August 4.  I don't know SQL, so I do
not know if you can create 2 date fields and use those in place
of the individual date sections.

Kevin Monahan
Sr Programmer/Analyst
JL Hammett Co
781-848-1000 x1114
www.hammett.com


> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
> Behalf Of Fisher, Don
> Sent: Thursday, June 06, 2002 2:23 PM
> To: 'rpg400-l@midrange.com'
> Subject: RE: RPGILESQL PGM
>
>
> The statement should look like this, I think:
>  C/EXEC SQL
>  C+ DECLARE C1 CURSOR  FOR
>  C+   SELECT * FROM PFfile where
>  C+     SNSCC >=:FC AND SNSCC <=:TC and
>  C+     SNSYY >=:FY AND SNSYY <=:TY and
>  C+     SNSMM >=:FM AND SNSMM <=:TM and
>  C+     SNSDD >=:FD AND SNSDD <=:TD
>  C/End-Exec
>
> You can also substitute "SNSCC between :FC and :TC" for the "SNSCC >= :FC
> and SNSCC <=:TC" conditions.
>
> Hope that helps.
>
> Donald R. Fisher, III
> Project Manager
> The Roomstore Furniture Company
> (804) 784-7600 extension 2124
> DFisher@roomstoreeast.com
> _______________________________________________
> 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.
>
>