Archives of the TeradataForum

Message Posted: Wed, 29 Mar 2006 @ 15:39:53 GMT

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

Hi Michael,

I had a sniff of the sign making the count to 11. I am currently using an E-LT tool called Sunopsis which automatically generates a FASTEXPORT script and runs it using FASTEXPORT utility, while exporting data from Teradata. It however converts every column into a CHAR(n) type (n being the column length of the table). Here is the sample log file with select query in it

     ..........
     0004 .EXPORT OUTFILE d:/files/employee.txt
           FORMAT text
           MODE record;

     0005 select
              EMP.employee_number (char(10)),
              ','      (char(1)),
             EMP.manager_employee_number    (char(10)),
             ','      (char(1)),
             EMP.department_number (char(10)),
             ','      (char(1)),
            EMP.job_code (char(10)),
     ...........

With your insights, I am now able to exactly pinpoint the root cause of the problem. Thanks for the help.

Regards,

Sidharth Kunnath
Teradata Consultant.

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