Archives of the TeradataForum
Message Posted: Sun, 02 Sep 2007 @ 18:20:32 GMT
| Subj: | | Re: ODBC TIMESTAMP math problem (datatype - or ANSI Date Time error) |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Sunday, September 02, 2007 10:58 -->
Capture the actual SQL being submitted to Teradata, e.g. using DBQL. Also do SHOW TABLE to verify the problem wasn't actually introduced
earlier by the ODBC driver adjusting DDL without your knowledge.
In your Windows ODBC data source configuration, set the "DisableParsing" option. In UNIX/Linux, set option "NoScan=Yes" in .odbc.ini, in the
[Default] section and/or the section for your specific data source name.
I always recommend people set those options, before they have a problem. You'll lose the ability to use ODBC escape sequences and function
calls, but the SQL generated / typed will be the SQL submitted. Note also that SQL Assistant overrides the DSN option setting based on the "Allow
use of ODBC SQL Extensions" option checkbox. Leave that un-checked.
Note also that if you change these options they take effect at next connect, so in the case of a middle-tier server you may need to recycle the
BI tool processes or reboot the server.
| 
