1) Not available till date(Don't know if Stinger has)
2) Yes
3) Use generated columns
CREATE TABLE TABLE1(FNAME CHAR(10),LNAME CHAR(10),LNAME_UPPER CHAR(10)
GENERATED ALWAYS AS UPPER(LNAME))
Index the generated column for indexes and select queries.
(Check the CREATE TABLE syntax in SQL Reference)
HTH
Sathyaram
www.db2click.com
Sathyaram Sannasi
Tel:01423-85-2461
-----Original Message-----
From: Thirumaran
[mailto:db2udbdba-ezmlmshield-x21248298.[Email address protected]
Sent: 16 June 2004 18:16
To: LazyDBA Discussion
Subject: function based index available in db2
Hi,
Version 7.2 /8.1
OS: windows,unix
1) Is function based index available in db2
2) Does DB2 has RANK,ROLLUP,CUBE functions (simillar to oracle 9i)
3) Is ther any alternate solutions for the above mentioned points
Thanks & Regards
Thirumaran
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]
**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of HPI Limited. If you are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited. If you received this email in
error, please immediately notify [Email address protected]
This message has been scanned by Panda Anti-Virus. Recipients are advised to
apply their own virus checks to this message on delivery.
**********************************************************************
DB2 & UDB email list listserv db2-l LazyDBA home page