Archives of the TeradataForum
Message Posted: Thu, 10 Jan 2008 @ 15:39:52 GMT
If this is truly how you want them to work do this in SQL-Assistant:
click on "Tools" in the menu bar, click on "Options" and under the Query tab, make sure that the option "Allow use of ODBC extensions" is not checked. Then LENGTH, RTRIM, LTRIM and several other non-ANSII/non-Teradata functions will no longer work in SQL-Assistant just like they don't work in FastExport or any other tool that does not use ODBC. As previously mentioned, with this option turned on in ODBC, it "helps" you by converting them to Teradata functions before passing them to the database. Which also means if you are not using these types functions, turning the option off stops ODBC from parsing your SQL before sending it to Teradata to be parsed. Makes you go "uhm."
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|