You can turn on a SQL trace in TDV to find out exactly what SQL your TDV server is receiving from the ODBC client. The steps are below.

(1)   Set Studio >> Administration >> Configuration >> Server >> Configuration >> Debugging >> "JDBC/ODBC Trace Level" to 3.

(2)   Run the query in the ODBC client.

(3)   Using a text editor, open cs_server_events.log and cs_server.log.and look for the query.

(4)  Compare the query in the logs with the  query that you entered in the ODBC client.

Example
If the query that you ran in your ODBC client is:
           SELECT DateOfBirth from AllCompanyRecords
then the log entries will look like this:

cs_server.log:
INFO [DBChannel-4] 2018-03-09 17:48:22.024 -0800 CsExec - CsExec [Thread_Name=DBChannel-4 Transcation_Id=3203948 Request_Id=3202938 SQL_Text=SELECT DateOfBirth from AllCompanyRecords ]

cs_server_events.log:
2018-03-09 17:48:22.024 -0800    INFO    START    request id=3202938 started    1    admin    composite    20100    6082586008097    6082586008097    3202938    SELECT DateOfBirth from AllCompanyRecords    examples    3203948    3301275    aprabhu-P51.na.tibco.com    ODBC    admin    composite    false

 

I suspect that my ODBC client may be altering the query before sending it to TDV. How do I check this possibility?