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

Parameters in the Configuration File-Optimization Flags Section

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 "datetime op string-literal" technically contains a datetime 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 datetime data type incompatibilities will be 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 datetime incompatibilities will still be 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;


 Siebel Analytics Installation and Configuration Guide, Version 7.7, Rev. A 
 Published: 11 March 2004