1.1 - 8.10 - Setting Teradata Studio to Create and Run Queries - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
Release Date
October 2019
Content Type
Programming Reference
Publication ID
English (United States)
To create and run queries in Teradata Studio™, you must set the JDBC property TMODE to TERA (by default, it is ANSI).
  1. Open the Properties dialog for the Database Connection.
  2. In the left pane, select Teradata JDBC Connection Properties.
  3. In the right pane, click Add.
  4. From the Select JDBC Property menu, select TMODE.
  5. From the Select Property Value menu, select TERA, then click OK.
  6. In the Properties dialog, click OK.