 |
 |
Archives of the TeradataForum
Message Posted: Thu, 07 Jul 2005 @ 20:22:14 GMT
| Subj: | | Re: Internal Format of MLOAD/FEXP data files |
| |
| From: | | Michael Larkins |
| | Does anyone know a way to take an "internal format" data file and output it somehow back out to VARTEXT mode, perhaps using one of the
utilities? | |
Have you considered running FEXP again using MODE RECORD and FORMAT TEXT with a SELECT that does a TRIM of a CAST to CHAR data with a literal
separator (ie ':') concatenated between each column?
Teradata is actually quite fast at this and much easier than converting and sorting a different file.
Hope this helps,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |
