Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Jul 2009 @ 07:31:30 GMT


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


Subj:   Column Headings in SQL Assistant
 
From:   Steve Hager

Why would the column headings in the SQL Assistant answer set be effected if a query begins with a new style comment?

This query:

     SELECT DATE AS column_title;

As expected produces:

     column_title
     07/09/2009

This query:

     --Test a comment
     SELECT DATE AS column_title;

Produces:

     A
     07/09/2009

Similar behavior is also exhibited if the result is exported to a file and the "Write column headers to the file" feature is enabled.


Steve Hager



     
  <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