About Using ASE with Client Utilities | Teradata Vantage - 17.00 - 17.05 - About Using ASE With Client Utilities - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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.