Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Oct 2009 @ 11:42:33 GMT


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


Subj:   CASE SPECIFIC SQL assistant mode setting
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, October 06, 2009 07:04 -->

Hi -

My SQL assistant session is working in the CASE SPECIFIC ANSI mode..I never switched to it. It is taking these SQLs differently

     sel * from dbc.tables where tablename like %TABLE1% ;

     sel * from dbc.tables where tablename like %table1%  ;

Any idea how can we turn the BTET mode on - using the SQL assistant window. set session transaction ansi is not working in the SQL assistant window. Also I am not sure how it switched to the ANSI mode. Are there some settings in the SQL assistant which could turn the BTET mode automatically.

Also blank (space bar) is appearing as "." in sql assistant.The scripts are not appearing correct. Please help me to change settings to normal.


Thanks and Regards



     
  <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