Using ASE with Client Utilities | Teradata Vantage - Using ASE With Client Utilities - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™
Except for the utilities and variables noted in the table that follows, you can use ASE with any utility that uses a standard Teradata Vantage interface to log on, including:
  • BTEQ
  • FastLoad
  • MultiLoad
  • Teradata Parallel Transporter
  • TPump (except for &T)
  • FastExport
  • Teradata Studio

The exceptions are described in the following table.

Do not use … With … Because …
TPump &T &T generates a row in AMPUsage for nearly every SQL statement.
PMPC statement any ASE code requests generated are not parsed and substituting variables cannot be expanded.