Using the Siebel Tools Version 8.0, Columns can be configured for CIAI, by easy to use Case Insensitivity UI wizard. This helps application users to query records irrespective of any case (Upper/Lower). E.g.
Here is the solution to implement the Confirmation popup applet (OK/Cancel) without Script in Siebel. This solution is applicable for both type of application (Standard and High Interactive application)
When the case insensitive and accent insensitive (CIAI) query feature is implemented, database queries you perform in the Siebel application ignore both case and the use of accents to return records that otherwise match the query criteria.
The Siebel File System stores all file attachments in a compressed format with a proprietary naming convention. Neither Siebel InterActive nor the Fulcrum SearchServer can access or read these files directly.
In most implementations, a high number of indexes already exist on some of the tables (such as, S_OPTY) and you must be careful not to add too many indexes. A new index can fix one query but may slow down another.
The 'Prefetch Size' and 'Max Cursor Size' is used for DB2 database. But there are some cases where Max Cursor Size alone has been used for Oracle database. The possible workaround is to run a default PDQ.