Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 10 Jan 2008 @ 15:39:52 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020