Sorry no.  Open enhancement request:

DefectID: 71624 : support for function based indexes

Patrick Kennedy
 Rational Support



-----Original Message-----
From: Visser, Cathi (CathiVisser) [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 4:06 PM
To: '[EMAIL PROTECTED]'
Subject: (ROSE) Oracle Functional Indexes



Is there any way to create Oracle functional indexes in Rose?

The following is the Oracle command to do it.
CREATE index fi_material_num on material ( SUBSTR(material_num,1,6)  );

Thanks

Cathi Visser



************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
*    http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*    To: [EMAIL PROTECTED]
*    Subject: <BLANK>
*    Body: unsubscribe rose_forum
*************************************************************************
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
*    http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*    To: [EMAIL PROTECTED]
*    Subject: <BLANK>
*    Body: unsubscribe rose_forum
*************************************************************************

Reply via email to