Archives of the TeradataForum

Message Posted: Thu, 16 Jan 2003 @ 15:03:13 GMT

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

Here is another way using fast export. You can imbed this in a shell script and cat the created file.

Personally, I don't know of a method that places only data to standard out. Teradata needs to work on this!

Personally, I find this superior to the bteq method.

.logtable  LOGTABLENAME;

.logon database/uid,pwd

.begin export
   sessions 20;

.export  outfile FILE.DAT format text;

select
       CAST(COL1 AS CHAR(99) )
      ,CAST(COL2 AS CHAR(99)  )
      ,CAST(COL,etc AS char(99))

from database.table
where WHERE PREDICATE CONDITION
sample 99;

.end export;

.logoff;

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