Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 31 May 2003 @ 09:36:23 GMT


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


Subj:   Re: BTEQ and RTRIM
 
From:   Dieter N�th

Paul Swier wrote:

  I have been trying to run a query in BTEQ using rtrim and I have not been succesful. Is it not possible? Below is a sample query. The mesage I receive is: *** Failure 3706 Syntax error: expected something between '(' and the word 'CHILDDB'.  


  select DISTINCT 'ALTER TABLE '||RTRIM(CHILDDB)||'.'|| CHILDTABLE ||' DROP CONSTRAINT '||INDEXNAME||'; ' from DBC.All_RI_Children where childdb<>PARENTDB  



RTRIM is ODBC SQL, it only works in QueryMan when you enable Option -> Query -> "Allow use of ODBC SQL Extensions in queries" and the ODBC driver replaces it with an Teradata SQL equivalent funtion (TRIM).

Please check the ODBC User Guide manual, table 4-16 for supported ODBC functions.

But i wouldn'd recommend using it, because the query won't run in a different environment.


Dieter



     
  <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