All Forums Teradata Applications
dineshks 3 posts Joined 05/16
04 May 2016
BTEQ - DELIMITER

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

dineshks 3 posts Joined 05/16
05 May 2016

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?

dnoeth 4628 posts Joined 11/04
05 May 2016

EXPORT REPORT was meant to be used for printinh, thus it removes all non-printable characters.
 
Use TPT with FORMAT = 'DELIMITED' instead.

Dieter

dineshks 3 posts Joined 05/16
06 May 2016

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

DiEgoR 33 posts Joined 08/06
24 May 2016

dineshks, have you seen this already? http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Load_and_Unload_Utilities/B035_2501_071A/2501Chap2.103.3.html

input output putput

You must sign in to leave a comment.