Archives of the TeradataForum

Message Posted: Fri, 12 Nov 2004 @ 14:10:35 GMT

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

We use a command:

     cut -c4-    file1 >> file 2

to trim the leading lrecl.

For EXPORT REPORT FILE....... so you do not get dashes:

     .TITLEDASHES OFF         /* This will turn off the dashes */

Then to remove the column title, do something like

     select    firstname (title '')
     from employee;

So you could do

     .bteq
     .login abcde
     .TITLEDASHES OFF
     .EXPORT REPORT FILE=myfile
     select firstname (title '') from employee;

I don;t have an answer about the number of records supported.

Hope this helps!

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