SQL Tools
Teradata provides two front-end SQL query products.
BTEQ
BTEQ stands for Basic Teradata Query utility. It is an SQL front-end that
runs on all client platforms. It supports both interactive ad hoc and
scripted batch queries and provides standard report writing and formatting
functionality. It also provides a basic import/export capability. Other
utilities are available for these functions, particularly when larger tables
are involved. When a user logs on with BTEQ, they can set the session
number they need before logging on. Using multiple sessions may
improve performance for certain operations.
Teradata SQL Assistant
Teradata SQL Assistant (formerly called
Queryman) is an SQL front-end
for Teradata, as well as any other ODBC compliant database. It offers a
full menu of services including query history, timings, status, row counts,
random sampling, and limited answer sets. It provides an import/export
feature between database and PC and also allows export to Excel and
Access.
No comments:
Post a Comment