Archives of the TeradataForum

Message Posted: Fri, 13 May 2005 @ 09:38:48 GMT

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

Hi,

I am generating a comma delimited file using FastExport. The file is getting generated fine with data. I need to have a header(column names) as a first line of the file followed by data and then I need to have a row count at the last line of the data file. I am on windows environment.Is there a sample code I can look into. I will really appreciate any guidance in this regard.

Below is my sample script:

     .LOGTABLE retail.empdept_fexp;
     .LOGON ..........
     .BEGIN EXPORT
            SESSIONS 20;
     .EXPORT OUTFILE C:\myarea\FEXP\retail_empdept
       FORMAT TEXT mode record;

     select
     cast(deptno as char(3))
            ||','||
            cast(empno as char(10))
            ||','||
            cast(ename as char(10)) (char(23))
      from retail.empdept1

     where......
     join conditions.....;

     .END export;
     .LOGOFF;

Thanks

Raj

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