BTEQ - DELIMITER

Teradata Applications

BTEQ - DELIMITER

How to give  '10'xc (hexadecimal 10) as delimiter in BTEQ script.in Unix it should be represented as ^p ?

4 REPLIES

Re: BTEQ - DELIMITER

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?

Junior Contributor

Re: BTEQ - DELIMITER

EXPORT REPORT was meant to be used for printinh, thus it removes all non-printable characters.

Use TPT with FORMAT = 'DELIMITED' instead.

Re: BTEQ - DELIMITER

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

Enthusiast

Re: BTEQ - DELIMITER