Archives of the TeradataForum

Message Posted: Thu, 30 Jun 2011 @ 09:33:52 GMT

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

Hi,

You can try to incorporate '|' after each attribute.

Ex:

     SELECT
       'Header:'   (CHAR(7)),
       '|'   (CHAR(1)),
       CAST(CURRENT_DATE AS DATE FORMAT 'DD.MM.YYYY')   (CHAR(10)),
       '|'   (CHAR(1))
     FROM
     DB.TABLE;

Hope this helps.

John

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