21 July 2018 · npac ·       Add to Favorites   Report

How to automate exports in tab-delimited form from Teradata fast export ?

We have the file export option in SQL Assistant 12.0, We can automate similar functionality using fast export which can be as a command or batch file

But in fastexport the result file has the rows with leading 2-byte length indicator which is annoying. To eliminate the 2-byte in the Fast Export output:


Make sure that the SELECT SQL must generate a fixed length export field. So you will inflate the size of the file and end up with a delimited but fixed length export file


posted on 21 July 2018

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too