×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I think that would be a "view" not an "index".
CREATE TABLE QTEMP/ASHISH (MYDATE DATE NOT NULL WITH DEFAULT,
MYDATA CHAR (5 ) NOT NULL WITH DEFAULT)
INSERT INTO QTEMP/ASHISH VALUES(current date, 'test')
INSERT INTO QTEMP/ASHISH VALUES(date('2011-01-31'), 'test')
CREATE VIEW QTEMP/ASHISHV1 AS SELECT * FROM qtemp/ashish WHERE
mydate=current date
select * from qtemp/ashishv1
MYDATE MYDATA
2011-05-20 test
This will not work
CREATE INDEX QTEMP/ASHISHi1 ON QTEMP/ASHISH (MYDATE)
where mydate=current date
This will:
CREATE INDEX QTEMP/ASHISHi1 ON QTEMP/ASHISH (MYDATE)
where mydate=date('2011-05-20')
Which I am willing to guess you do not want.
You could combine it with
CREATE INDEX QTEMP/ASHISHi1 ON QTEMP/ASHISH (MYDATE)
and
CREATE VIEW QTEMP/ASHISHV1 AS SELECT * FROM qtemp/ashish WHERE
mydate=current date
That way you get the performance benefit of an index with the selection of
a view.
Rob Berendt
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
