Siebel Analytics Installation and Configuration Guide > NQSConfig.INI File Reference > Siebel Analytics Configuration File Parameters and Syntax >

Parameters in the Configuration File Optimization Flags Section

There is one parameter in the Optimization Flags section, STRONG_DATETIME_TYPE_CHECKING. It is a special parameter used to override the behavior of the Siebel Analytics Server in certain situations.

STRONG_DATETIME_TYPE_CHECKING

Use this parameter to relax strong type checking to prevent some date/time data type incompatibilities in queries from being rejected. For example, a query of the form "datetime op string-literal" technically contains a date/time data type incompatibility and would normally be rejected by the Siebel Analytics Server.

Valid values are ON and OFF. The default value is ON, which means that strong type checking is enabled and queries containing date/time data type incompatibilities are rejected. This is the recommended setting.

To relax the strong type checking, set the value to NO. Note that invalid queries or queries with severe date/time incompatibilities are still rejected. The query could still fail, for example, if the relational database implements a similar strong type checking.

Example: STRONG_DATETIME_TYPE_CHECKING=ON;


 Siebel Analytics Installation and Configuration Guide
 Published: 09 September 2004