All Forums Tools
vincent91 14 posts Joined 02/10
07 Jan 2015
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
 

feinholz 1234 posts Joined 05/08
14 Jan 2015

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

You must sign in to leave a comment.