Archives of the TeradataForum
Message Posted: Fri, 09 Jul 2004 @ 13:04:55 GMT
| Subj: | | Re: Windows-based Fast Export Script |
| |
| From: | | Rob Paller |
You will likely need to wrap your extract query with a SEL statement that concatenates everything together using the delimiter of your choice
and CAST it to the maximum length you expect from each column.
If your export is variable width, FastExport will append a 2 byte character string to the beginning of each row to indicated it's length.
This is used by the other Teradata utilities and useless as far as SQL Server will be concened. You can either have SQL Server ignore the first
two characters (probably the easiest) or you can write an OUTMOD in C that will strip the leading two characters.
The TeradataForum website should have a link to a UNIX version that is easily modified to work with Windows. I have used the UNIX code myself
to do just what I explained above.
--
Rob Paller
Teradata Certified Master
| 
