Archives of the TeradataForum
Message Posted: Wed, 21 Mar 2001 @ 23:40:42 GMT
"There's a tool for every job" - I agree with that, but unfortunately there is not a tool for exporting large amounts of data from Teradata with a delimiter.
BTEQ is too slow to use on more than 1 or 2 thousand records.
You can write an outmod for FastExport but this is very time consuming and maintenance heavy.
You can put the delimiters in the SQL of the FastExport, but this is tedious and less than ideal.
The only other option is to pass the data through a filter after the FastExport - which is better than nothing I suppose.
I do not see why providing the option for delimiters in FastExport would affect those users who DO NOT wish to use it. Like all options it is OPTIONAL and therefore could be implemented so that it would not affect those users who do not wish to use it. This solution would be ideal for those users who have a real need to have large amounts of delimited data.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|