Re: substring date fields in logical files

Why create the logical in the first place?
Can't you already do
select * from qtemp/james where year(mydate)=2002
select * from qtemp/james where month(mydate)=11
select year(mydate), month(mydate), mydate, myfield
from qtemp/james
order by mydate desc
YEAR ( MYDATE )  MONTH ( MYDATE )  MYDATE    MYFIELD
         2,002                 2   02/28/02  test
         2,002                 1   01/31/02  test
         2,001                12   12/05/01  test
         2,001                11   11/13/01  test

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    James Rich
                    <james@eaerich.com>       To:     midrange-l 
<midrange-l@midrange.com>
                    Sent by:                  cc:
                    midrange-l-admin@mi       Fax to:
                    drange.com                Subject:     substring date 
fields in logical files


                    08/08/2002 03:38 PM
                    Please respond to
                    midrange-l






I have a physical file that contains a date field in it.  I want to create
a logical file over it that is keyed by just the year and month portion of
the date field.  The DDS manual tells me that I can't use SST on date
fields.  Anyone know a way I can create a field in a logical file that is
a portion of a date field?

James Rich

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.