when i use .EXPORT REPORT FILE mode am not getting ^p in my output as delimiter but when i use .EXPORT DATA mode am getting ^p as the delimiter but the data is in unreadable binary form. Is there a way to resolve this issue?
EXPORT REPORT was meant to be used for printinh, thus it removes all non-printable characters.
Use TPT with FORMAT = 'DELIMITED' instead.
i need to export all the tables from a set of databases.using bteq i have created a file with select statements for all required tables. like select * from database name.tablename; for all tables.can you provide a sample script to just run this file in TPT and load it into a file. because i found from examples in net that we should provide columns in schema that is not possible in this case
dineshks, have you seen this already? http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00