Archives of the TeradataForum
Message Posted: Tue, 30 Oct 2007 @ 13:30:51 GMT
Subj: | | Re: Unchecking the 'Allow Use of ODBC SQL Extensions in queries' for Microstrategy |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Tue, 30 Oct 2007 08:25 -->
I always recommend people DisableParsing (turn off ODBC SQL Extensions) unless they have a darn good reason to enable it. The only things that
stop working are things that are not valid Teradata SQL in the first place like LEFT function or literals in ODBC format (with braces) which the
driver tries to "fix" on the fly - meaning the SQL presented to the database is not necessarily what the client submitted.
MicroStrategy should not be using any ODBC extensions, especially with VLDB properties set to Teradata.
|