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

Optimization Flags Section Parameters in the Configuration File

There is one parameter in the Optimization Flags section. It is a special parameter 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 "date/time 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. Note also that the query could still fail, for example, if the relational database implements a similar strong type checking.

Example: STRONG_DATETIME_TYPE_CHECKING=ON;