How can I perform the same with a TPT script ?

Tools & Utilities
Enthusiast

How can I perform the same with a TPT script ?

Hello ,

 




I use very often this kind of code based on bteq export and I do not know how to turn it on TPT ?


Thanks for your help

bteq << EOF

 .logon ${CNX_SRC};

 .set width 5000;

 .EXPORT DATA FILE=${FIC_DDL_TABLE_SRC}

 .SET RECORDMODE OFF;

 .set titledashes off;

 show table  ${SRC_TBL};

 .IF ERRORCODE <> 0 THEN .QUIT 1

 show stat on ${SRC_TBL};

 .QUIT 0

EOF

Tags (1)
1 REPLY
Teradata Employee

Re: How can I perform the same with a TPT script ?

BTEQ can sometimes be viewed as a report writer type of tool.

TPT is not.

TPT is a data loading tool (yes, it can export from a database as well, but the power of TPT is in its loading).

TPT cannot (and will not) support the type of data output as BTEQ when writing to files.

Why do you want to use TPT for those type of actions?

They are much better suited for BTEQ anyway.

-- SteveF