Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 30 Jul 2004 @ 11:36:48 GMT

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

Subj:   Re: ODBC functions and Teradata SQL.
From:   Victor Sokovin

  See the "ODBC 2.0 Reference Guide and SDK", Ch. 14 "Processing an SQL Statement" and Appendix F "Scalar Functions" for more information. Sorry, but I don't have the ODBC 3.0 references available.  

That was an interesting reference for me; thanks for posting it. It dates back to 1996 and that was long before I started working with TD. I now better understand where you are coming from.

When I looked at the list of functions in 2.0 I was surprised how much useful stuff was there, especially in the area of string manipulation and dates / times. Were all of them really implemented in 2.0 (I doubt ...)? As far as the number of built-in functions is concerned, 3.0 looks really on the low-budget side by comparison.

  RECAUZR6H / DR68180 addresses the mishandling of ODBC extensions to SQL by the Teradata ODBC driver. At last report, the fixes are planned for inclusion in TTU 8.0. The ODBC extension syntax looks like:  

  {fn <myfunc>}  

  in general or  

  {fn length(mycol)}  

  in specific. The Teradata driver is not requiring the escape characters in all cases (length, left, right, and others), and allows, for example, a simple length(mycol) to pass syntax.  

What is the intention of this change request? Will BTEQ in some future release be able to intelligently convert ODBC escaped functions to native functions? If not, then we will only have to type more characters in Queryman et al but the code will still be foreign to BTEQ (I understand that is your main concern). Am I missing something?



  <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: 27 Dec 2016