Query Development | Use the SQL Editor | Teradata Studio/Studio Express - Using the SQL File Editor - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-20
dita:mapPath
rvy1605890559220.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
The Teradata SQL Editor supports:
  • Vantage connection profiles
  • Aster Database connection profiles
  • Hadoop File System connection profiles with JDBC enabled

If you are working with SQL files located on a different type of database, such as Oracle or MS SQL Server, you must work in the SQL File Editor.

  1. Do one of the following:
    • In Project Explorer, right-click the SQL folder.
    • Open the SQL Editor and right-click in the main editor pane.
  2. Select Open With > Other....
    The Editor Selection dialog appears.
  3. Select SQL File Editor.
  4. Click OK.
  5. Under Connection Profile, select the Type of database for this connection; for example, Oracle_10 or SQL Server_2005.
  6. Select the Name of the connection profile from the list.
    Only existing connection profiles display in the list.
  7. Select the Database name from the list.
    Aster and Hadoop have no database name.
  8. Verify the status of the profile you selected.
    Status information displays to the right of the Database name. If no connection profile exists for a particular profile type, the Name and Database fields are blank.