To configure Advanced SQL Engine, use any client application that can run SQL requests, such as Teradata Studio or Basic Teradata Query Utility (BTEQ). These client applications allow users to:
- Perform administrative tasks, including creating databases, tables, and views using SQL DCL, DDL, and DML requests.
- Format reports for both print and screen output.
For the sake of simplicity, the following procedures for configuring Advanced SQL Engine use only BTEQ to access the database.
For example, in Windows, click the Microsoft logo on the lower left of your screen and in the dialog box type: Run.
- In the Open box, type cmd to open a command window.
- Type BTEQ.
Enter, for example: .logon systemname.your_company.com/dbc;
where systemname is the primary database node (the name by which the Vantage system is known to the network, also called the TDPID).
- Type password dbc.