Archives of the TeradataForum

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

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

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>>