The TIBCO Data Virtualization Server-level configuration for the CASE_SENSITIVITY and TRAILING_SPACES parameters can be adjusted via Studio > Administration > Configuration affecting all datasources and at datasource-level the configuration can be done by editing the <DS_name_version>_values.xml file located at '<TDV_INSTALL_DIR>\conf\adapters\system\<DS_name_version>.' in TDV. However, there may be instances where a user needs to modify these values for a specific query.
For instance, if performance issues arise due to the increased size of a particular dataset/table, such as with NOSQL table of datasources like Cassandra and Azure Table Storage, or when designing a new query returning optimal results for case-insensitive comparisons. In such cases, altering the server-level/datasource-level configuration is impractical as it impacts the whole datasource/s and we only want to adjust the configurations for a particular query. A more suitable approach is briefed below.

This article will explain the method using which the default configuration of CASE_SENSITIVITY and TRAILING_SPACES can be changed/ignored for any query.

All Supported Environments.

The query level case-sensitivity can be changed by adding the below query hint:

SELECT {OPTION CASE_SENSITIVE="false", IGNORE_TRAILING_SPACES="true" } *
FROM table1
WHERE column1 = ’xyz’;