Using the SQL File Editor - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities
The Teradata SQL Editor supports:
  • Teradata Database 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 displays.
  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.