 |
 |
Archives of the TeradataForum
Message Posted: Thu, 10 Jan 2008 @ 15:39:52 GMT
| Subj: | | Re: Not a question, but an interesting circumstance |
| |
| From: | | Michael Larkins |
Hello Menno:
You wrote:
| | But if you're interested: try to get LENGTH (that works fine in queryman) to work in a FastExport script. You would assume all tools of the
same vendor would support the same commands, right? | |
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,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |
