Archives of the TeradataForum

Message Posted: Tue, 09 Aug 2005 @ 14:06:18 GMT

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

Hi Vijay

You can cast your fields to varchar and append with a comma

That should solve your problem

Here is a sample script

     .export report file=fil1.csv
     -- Detail csv
     sel case when f1 is null then '' else f1 end  ||','||
         case when f2 is null then '' else  f2 end  (title '')
     from tablename
     ;
     .export reset;

We have the limitation of 254 characters in Bteq if your columns exceeds 254 then the remaining part of the file gets chopped of

May be you can try to use fast export the same SQL scripts work on both there you donot have the problem with width of the file

Hope this helps

Sudha Muthusamy

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