|
|
Archives of the TeradataForum
Message Posted: Wed, 29 Mar 2006 @ 15:39:53 GMT
Subj: | | Re: Cast Operator |
|
From: | | Kunnath, Sidharth |
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.
| |