So this applies only to code (ie. as it says below, Active links, filters, escalations). Not end-user queries, correct? Terry
_____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hullule, Kiran Sent: August-29-13 9:26 AM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** Yes there is a real enhancement, see this info: Db-Case-Insensitive 1 Flag indicating whether to perform case-insensitive queries on Run If qualifications for active links, filters, and escalations. (For Oracle databases, ensure that this option matches the behavior of your Oracle database so that all queries are consistent.) Valid values: . T - Performs case-insensitive search , By default, the AR System server creates regular indexes when you add an index to a form. To support case-insensitive searches on Oracle databases, functional indexes are required instead of regular indexes. To change the AR System server's default behavior for index creation, set the Db-Functional-Index parameter to T. Then, when a new index is added to a form, the AR System server creates a functional index for the form. This parameter helps to avoid performance degradation that can result from not using database indexes. The Db-Functional-Index parameter is ignored if Db-Case-Insensitive is set to F or if it is absent from the ar.cfg file. The Db-Case-Insensitive and Db-Functional-Index parameters handle new indexes. In the database (outside of the AR System server), you must manually convert any existing indexes to functional indexes. BMC provides an unsupported Oracle Functional Index Helper.bat utility to manage these existing indexes and to convert them from regular to functional indexes. You can find this unsupported utility in the ARServerInstallDirectory\Arserver\api\lib folder. Due to known issue with Oracle, set cursor sharing to EXACT so that the query optimizer can use functional indexes for LIKE queries. For help, see your database administrator. Note: While running the Oracle Functional Index Helper.bat utility for existing forms, you might see the following error: Error message ERROR (552): The SQL database operation failed.; ORA-00942: table or view does not exist. This occurs because indexes are not applicable on vendor, view, display-only, and join forms. . F (the default) - Performs case-sensitive queries. For optimal performance when using database indexes for case-insensitive searches on Oracle, ensure that: . The Oracle client is at least version 11.2. . The database administrator sets cursor sharing to EXACT for the functional indexes that Oracle Optimizer will use (otherwise, performance can be severely degraded due to full table scans). Note: Depending on the volume of data, creating functional indexes may take a long time. If anyone has question related to this feature please let me know. Regards, Kiran H From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: Thursday, August 29, 2013 6:49 PM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** I think the option can now be: Db-Case-Insensitive: true or Db-Case-Insensitive: TRUE Good to see it made the list of enhancements. Could you imagine if the Case-Insensitive option was case-sensitive. Keep Calm - Remedy On. -John On Thu, Aug 29, 2013 at 7:10 AM, Sagar G Anandpara <sagar_anandp...@infosys.com> wrote: Thanks Shawn for the reply. With regards to the Similar Subject Line, I have one more similar doubt in the section Other Enhancements in v8.x- The Documentum says "The Db-Case-Insensitive option in the ar.conf (ar.cfg) file was improved". Again, the option was available with v7.6.04 as well, but would like to know what and how exactly its been improved. Thanks, Sagar ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" -- John Sundberg Kinetic Data, Inc. "Your Business. Your Process." 651-556-0930 I john.sundb...@kineticdata.com <http://www.kineticdata.com/> www.kineticdata.com I <http://community.kineticdata.com/> community.kineticdata.com _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
