Tags for btet
BTET/ANSI Transaction in TPT/FASTLOAD
Hi All, I am having one problem. I know BTET transaction is "all or none". If I submit a multistatement transaction and any one statemetn fails then entire transaction will roll back in BTET mode. However in ANSI mode if I use COMMIT then only the failed statements will roll back while the others will commit.
tpt fastload btet transaction mode
BTEQ Reference 13.10
This book provides reference information about BTEQ (Basic Teradata Query), a general-purpose, command-based report and load utility tool. BTEQ provides the ability to submit SQL queries to a Teradata Database in interactive and batch user modes, then produce formatted results.
udf load teradata bteq lob sql export import compile xsp pack batch btet tdpid logon v_tools