Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 28 Apr 2005 @ 14:44:10 GMT

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

Subj:   Re: SQL using Ltrim function
From:   Victor Sokovin

  The above SQL runs fine on SQL assistant 6.1 but does not run when i submit it from mainframe through BTEQ v08.02.01.00.  

Try TRIM instead of LTRIM.

  Is there a configuration in SQL assistant that controls this(or probably an ODBC feature) because of which this SQL runs fine?  

It must be an ODBC function. There is a possibility in the SQLA options to disable ODBC extensions.

  Is there a way to make this work on BTEQ without changing the code?  

No, because LTRIM is not a TD function and Bteq does not use ODBC.



  <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: 15 Jun 2023