 |
 |
Archives of the TeradataForum
Message Posted: Fri, 04 Aug 2006 @ 09:36:42 GMT
| Subj: | | Re: Delimited FEXPORT/BTEQ EXPORT |
| |
| From: | | Victor Sokovin |
| | I was trying to export data by using a delimiter '~' Fexport did not accept FORMAT as VARTEXT and provides only TEXT. please let me which
is the best possible way to create a delimited file. | |
Unless something changed in the recent versions, the standard recommendation remains to put the delimiter between the list of columns in the
SELECT:
sel col1 || '~' || col2 || '~' || .... || colN
from the_table;
| | Does creation of delimited files is supported in bteq export.If so what is the settings that needs to be done. | |
The above works for bteq as well.
Regards,
Victor
| |
