Archives of the TeradataForum

Message Posted: Mon, 21 Feb 2005 @ 16:03:31 GMT

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

I think what you need to do is specify (title '') after each column selected as follows:

     .logon tdp0/dba;
     .set width 254;
     .set titledashes off;
     .set maxerror 0;
     .set errorout stdout;

     select ' database '||trim(:tdb)||';' (title '')
     ;select 'CREATE TABLE xxxxx (c1 VARCHAR(30),c2 VARCHAR(100),c3
     VARCHAR(5000),  c4 VARCHAR(30))' (title '')
     ;select 'PRIMARY INDEX (c1);' (title'')
     ;

Etc.

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